1，用原sql语句
<?php
function get_order_data($goods_id)
{
$db = &db();
$sql = "select a.buyer_name, a.add_time, a.status, b.phone_tel, b.phone_mob, c.price,";
$result = $db -> query($sql);
$r = array();
while($myrow = $db -> fetch_array($result)){
$r[] = $myrow;
}
return $r;
}
?>
原文：http://www.cnblogs.com/xiaoxiaomengxiangjia/p/5614921.html