/PHP/Laravel/Laravel get all users except role spatie

Laravel get all users except role spatie

You can make 2 querys to get both groups of users that you want. I mean:

1) Users who dont have any role.

User::whereDoesntHave('roles')->get();

2) Users have any role, but not admin (from Adam Kozlowski answer)

$this->users()->whereHas('roles', function ($query) {
    $query->where('name','!=', 'admin');
});

Similar codes

0 vote385 views1 answer
Get nearby from longitude and latitude in laravel
PHP Laravel
0 vote395 views1 answer
If session is empty laravel
PHP Laravel
50 votes476 views6 answers
Add column in laravel migration
PHP Laravel
11 votes374 views3 answers
Remove package in laravel
PHP Laravel
1 vote438 views1 answer
I cannot login to my CPanel hosted Laravel Application, my SSL has expired
PHP Laravel
3 votes351 views1 answer
Phone number validation, laravel
PHP Laravel
63 votes527 views6 answers
Clear all cache in laravel
PHP Laravel
1 vote355 views1 answer
Check which database connect laravel
PHP Laravel
1 vote434 views2 answers
Laravel seconds to hours minutes seconds
PHP Laravel
4 votes404 views3 answers
Laravel cmd command to watch logs
PHP Laravel