return $this->hasManyThrough('User', 'GroupUser', 'userid', 'id');,控制器中的代码:$datas = $data->users()->field('user.id,user.username,user.status,user.sign,user.avatar')->select();,但是执行后的SQL语句是:SELECT `user`.*,`user`.`id`,`user`.`username`,`user`.`status`,`user`.`sign`,`user`.`avatar` FROM `user` `user` INNER JOIN `group_user` ON `group_user`.`group_id`=`user`.`id` INNER JOIN `groups` ON `groups`.`id`=`group_user`.`userid` WHERE `group_user`.`userid` = '1' 最佳答案