laravel如何直接返回关联数据
例:partners表,通过连接直接返回users和companies表里的数据
$partner= new Partner;
$data = $partner
->leftjoin('users','partners.create_by','users.id')
->leftjoin('companies','partners.company_id','companies.id')
->select('partners.*','users.username as create_by','companies.companyname as company_name')
->get();
return $data;
如果有需要传值查询后关联
例:partners表查询id后,通过连接直接返回users表里的数据
$data = Partner::where('partners.id',$id)
->leftjoin('users','partners.create_by','users.id')
->select('partners.*','users.username as create_by')->first();
return $data;