TP5.0 商城订单查询(多订单下多商品)

$order = Db::name('order')->where('uid',session('uid'))->select();//个人订单信息
foreach ($order as $key=>$v){

    $sid = explode(',',$v['sid']);//拆分订单中商品ID(数据库设计:商品id逗号拼接)
    $order[$key]['s'] = $sid;//订单里面所包含的商品信息
    foreach ($order[$key]['s'] as $index => $item) {
        $goods = explode('|', $item);//拆分获得对应的下单数量(数据库:商品ID|商品数量,商品ID|商品数量)
        $goods_info = Db::name('shop')->where('sid',$goods[0])->find();
        $order[$key]['s'][$index] = [
            'goods_info'=>$goods_info,//一个商品信息里面的商品详情
            'goods_num'=>$goods[1],//数量
        ];
    }
}