如何检索与多个角色关联的用户，如[“role1”，“role2”...]

Question

I have users and roles relationship as belongsToMany. I now want to get all users have multiple roles by names.

I have tried as,

 $role_ids = [1,2];
 $users = User::whereHas('roles' , function ($query) use($role_ids) {
            $query->whereIn('roles.id', $role_ids);
        })->get();

But this approach gives me users who are associated with both or either one roles which is not i am expecting

Answer 1

You'll have to add multiple whereHas for that:

$role_ids = [1,2];
$users = User::with('roles');
foreach($role_ids as $role){
    $users->whereHas('roles', function($q) use ($role){
        $q->where('roles.id', $role);
    });
}
$users = $users->get();