Laravel with指定查询字段

Laravel关联模型指定查询字段

常见写法

ActiveJieSuan::with(['user' => function ($query) {$query->select('id','name');},
   'active'=> function ($query) {
                $query->select('id','name','start');
    }
])->paginate()->toArray();

简介写法

$res = $query->with(['details:from_id,remark,deal_name'])->orderBy("create_time", "desc")->offset(($params['page'] - 1) * $this->pageSize)->limit($this->pageSize)
            ->get(['id','title','create_time','status','edit_user_id']);

注意：查询字段必须要有关联的字段，不然查出来的是null