How to complement these queries to get the buyer’s data in the bank?

Question

I made these queries below to get the data from the buyer’s database and the products he bought. With the first query, I got the ID and with these IDS I made a new foreach that took the products that each ID acquired.

What I needed now was to compare the ID order with other table containing the customer data having that determined ID. This table is with 99% chance this one >>> wp_postmeta. We are talking about Wordpress but the query can be SQL native even.

I’ll show you what I did and what I got:

global $wpdb;

$sqlSelect  = "SELECT ID FROM wp_posts WHERE post_type = 'shop_order'";

/* Buscando os IDS da Compra */
$pid = array();    
foreach ($wpdb->get_results($sqlSelect) as $dados) {
    $pid[] .= $dados->ID;
}

/* Buscando os produtos comprados pelo ID */
foreach ($pid as $uid) {
    echo '<strong>Número do pedido: ' . $uid . "</strong><br>";
    $sqlDados = "SELECT * FROM wp_woocommerce_order_items WHERE order_id = '$uid'";
    foreach ($wpdb->get_results($sqlDados) as $itens) {
        echo $itens->order_item_name . '<br>';
    }
    echo '<br>';
}

This query returned me this:

Now all I need to do is return the customer’s data to be able to do my program. You can help me?

Table preview wp_postmeta ...

Answer 1

Example of JOIN

$sqlSelect  = 'SELECT pt.ID, woi.*, cli.* '
          . 'FROM wp_posts pt '
          . 'INNER JOIN wp_woocommerce_order_items woi ON (woi.order_id = pt.id) '
          . 'INNER JOIN wp_nome_tabela_clientes cli ON (cli.id = pt.cliente_id) '
          . 'WHERE pt.post_type = "shop_order" ';