build a mysql statement with array output

sorry this is not a big job but it is needed asap. I need to have a multi-dimensional array built. Here is what i have. tables orders where customers_id = $row['customers_id'] orders_products_attributes where orders_id = orders_id from orders orders_products_download where orders_id = orders_id from orders orders_status_history where orders_id = orders_id from orders orders_total where orders_id = orders_id from orders i am only posting a few fields to you get what i need in the end i need this out put. order array ( [orders_id] => 104 [customers_id] => 62 orders_products_attributes array ( [orders_id] => 104 [products_id] => 332 [products_model] => wbp17 ) orders_products_attributes array ( [orders_id] => 104 [orders_products_id] => 108 [products_options] => Download ) ) there is a lot of fields but this should give you the just of what i need. The end goal is i am sending the data over via curl to a file that will insert the data into a new database. I have everything written up to this point but this part to pull and insert the orders with new ids and stuff. any help would be appreciated.