使用Laravel的Eloquent关系的错误

Question

I have 2 models - User and RoleUser. Each user is assigned to a role. So I defined a one-to-one relationship by declaring a 'role' method on the User model.

 public function role(){
        return $this->hasOne('Vanguard\RoleUser', 'user_id');
 }

This is my Role Model

class RoleUser extends Model
{
    //
    public $table = 'role_user';

    protected $fillable = ['user_id', 'role_id'];

}

In controller, I am trying to fetch users with role_id = 2 but the query keeps returning all users (i.e. 3) instead of just one user. This is my controller

 $users = User::with(['role' => function ($query) {
            $query->where('role_id', 2);
        }])->get();

Please what is causing this?

Answer 1

Using a scope with with will only add the scope to the eager loaded relation, regardless of if it exists. To achieve what you want you need to do a whereHas too.

$users = User::whereHas('role', function ($q) {
    $q->where('role_id', 2);
})->with(['role' => function ($q) {
    $q->where('role_id', 2);
}])->get();