// start
$speceal_order=\App\BaseOrderModel::leftjoin('ys_sub_order','ys_sub_order.base_id','=','ys_base_order.id')
->leftjoin('ys_order_goods','ys_sub_order.id','=','ys_order_goods.sub_id')
->leftjoin('ys_goods','ys_goods.id','=','ys_order_goods.goods_id')
->leftjoin('ys_goods_class','ys_goods_class.id','=','ys_goods.class_id')
->where('ys_base_order.state',1)
->where('ys_sub_order.receive_state',1)
->where('ys_sub_order.all_rebate','>',0)
->where('ys_sub_order.back_state',0)
->groupBy('ys_base_order.user_id')
->select('ys_order_goods.*','ys_goods.class_id','ys_goods_class.first_id')
->get();
@file_put_contents($path.'/speceal_order.txt', print_r($speceal_order,true));