*/
public function lfGetOrder()
{

$objQuery =& SC_Query_Ex::getSingletonInstance();

$this->arrOrder = array();
foreach ($this->arrBestProducts as $bpKey => $bpVal) {

$product_id = $bpVal['product_id'];

// 消費税は想定していない
$dbSQL = <<< __EOS__
SELECT dtb_order_detail.*
FROM ( SELECT * FROM dtb_order WHERE del_flg = 0 ) AS dtb_order
LEFT JOIN dtb_order_detail
ON dtb_order.order_id = dtb_order_detail.order_id
AND dtb_order_detail.product_id = ?
WHERE dtb_order_detail.product_id = ?
__EOS__;

$arrResult = $objQuery->getAll($dbSQL, array($product_id, $product_id));

foreach ($arrResult as $key => $val ) {
//// 総合件数・総合金額
$this->arrOrder[$product_id]['quantity'] += $val['quantity'];
$this->arrOrder[$product_id]['price'] += ($val['price'] * $val['quantity']);
}

}

}


}


商品詳細を結合したいんですがどうやってやりますか？