Select distinct
`users`.`name` as user_name,
`practices`.`name` as practice_name,
`userlevels`.`name` as userlevel_name,
`usertypes`.`name` as usertypes_name,
`users`.`active` as user_status,
`users`.`email` as user_email
from `network_user`
left join `users` on `network_user`.`user_id` = `users`.`id`
left join `practice_user` on `users`.`id`=`practice_user`.`user_id`
left join `practices` on `practice_user`.`practice_id`=`practices`.`id`
left join `userlevels` on `users`.`level`=`userlevels`.`id`
left join `usertypes` on `users`.`usertype_id`=`usertypes`.`id`
where `network_user`.`network_id`= 9
;
这是我的sql原始查询,我是雄辩面对问题的新手,任何人都可以告诉我如何在雄辩中重命名属性。谢谢。
请尝试以下方法:
$users = DB::table('network_user')
->leftJoin('users', 'users.id', '=', 'network_user.user_id')
->leftJoin('practice_user', 'practice_user.user_id', '=' ,'users.id')
->leftJoin('practices', 'practices.id', '=', 'practice_user`.`practice_id')
->leftJoin('userlevels', 'userlevels.id', '=', 'users.level')
->leftJoin('usertypes', 'usertypes.id', '=', 'users.usertype_id')
->where('network_user.network_id', 9)
->get(['users.name as user_name',
'practices.name as practice_name',
'userlevels.name as userlevel_name',
'usertypes.name as usertypes_name',
'users.active as user_status',
'users.email as user_email']);
尚未测试,但应该可以工作。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句