php - Codeigniter Eloquent 查询关系

Question

我有两个这样的表:

用户:users_id |姓名 | users_roles_id

users_roles:users_roles_id |角色

我想加入这些表。我尝试了以下方法:

use Elegant\Model as Eloquent;

class User extends Eloquent {
    protected $table = 'users';

    function getRoles($userId){
        User::join('users_roles', 'users_roles.users_roles_id', '=', 'users.users_roles_id')
            ->select('*')
            ->get();    
    }

    public function user_role() {
        return $this->belongsTo('users_roles','users_roles_id');
    }
}

但我不知道如何加入这些来显示它。谢谢

Answer 1

我做了

    class User extends Eloquent {
        protected $table = 'users';

        function getRoles($userId){
            return $this->where('id', $userId)->join('users_roles', 'users.users_roles_id = users_roles.users_roles_id')->get();  
        }
    }

它正在工作 ;-)