控制器
$info = OptimizationShoporder::with(['user'=>function($query){
$query->field('id,username,mobile');
},'stock'=>function($query){
$query->field('id,date,attribute_id');
},'goods'=>function($query){
$query->field('id,title');
}])->where(['shops_id'=>$user_id])
->whereIn('status',[1,2,3,4,6])->limit($start,5)->order('createtime','desc')->field('num,iprice,dprice,tprice,zprice,status,
goods_optimization_stock_id,goods_id,merchant_id,userid,order_number,order_id')
->select();
模型
public function goods()
{
return $this->belongsTo('TravelGoods','goods_id','id');
}
public function stock()
{
return $this->belongsTo('app\admin\model\GoodsOptimizationStock','goods_optimization_stock_id','id');
}
public function merchant()
{
return $this->belongsTo('TravelMerchant','merchant_id','id');
}
public function user()
{
return $this->belongsTo('User','userid','id');
}