Get all users with role in Laravel

Question

I'm working in this Laravel project which has this structure

users: id | first_name |...

roles: id | name

assigned_roles: id | user_id | role_id

I think this is quite obvious :p

User model

class User extends ConfideUser {
use HasRole;

public function Roles(){
    return $this->belongsToMany('Role','assigned_roles');
}

Role model

class Role extends EntrustRole
{
public function Users()
{
    return $this->belongsToMany('User','assigned_roles');
}


} 

I'm looking for a way to get all users with a specified role in this case 'Teacher'. I've tried this:

$students = User::with(array('Roles' => function($query) {
        $query->where('name','Teacher');
    }))
    ->get();
    return $students;

but this always returns an array of all users.

would anyone know why that's so? Thanks!

Besprent

Answer 1

What you're currently asking laravel for in your $students query, is 'give me all the students, and for each student get me all of their roles if the role is teacher'

Try using the whereHas

$students = User::whereHas(
    'roles', function($q){
        $q->where('name', 'Teacher');
    }
)->get();

This should get you the users, but only where they have a role where the name is teacher.

Kiaochow

Are there other ways to retrieve this, because this might have performance issues. Should we consider using index on user_id on role? – Primipara

You could use this package which is very nice, github.com/mpyw/eloquent-has-by-non-dependent-subquery – Heirship

Answer 2

If you are using spatie/laravel-permission or backpack/permissionmanager you can simply do:

$teachers = User::role('Teacher')->get();

Naples

Answer 3

In case you want to get all users with a list of potentials roles:

$authorizedRoles = ['Teacher', 'Professor', 'Super professor'];

$users = User::whereHas('roles', static function ($query) use ($authorizedRoles) {
                    return $query->whereIn('name', $authorizedRoles);
                })->get();

Systaltic

Answer 4

Try This.

Role::where('rolename', 'user')->first()->users()->get()

Westnorthwest

Answer 5

If You Are using laravel-permission package then,

In Controller,

$rolesWithUserCount = Role::withCount('users')->get();

In Blade File,

@foreach ($rolesWithUserCount as $item)
          {{ $item->name }}
          {{$item->users_count }}
@endforeach

OutPut:

Role1 Role1Count 
Role2 Role2Count
 ....

For More: VISIT: https://laravel.com/docs/7.x/eloquent-relationships#counting-related-models

Lekishalela

Answer 6

This would work exactly as intended:

$users = User::whereHas('roles' => function($q){$q->where('name', 'Teacher');})->get();

Casa