Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
Hello,
I am using spattie and would like to only show users with the role "user".
But when I use this query:
$users = User::whereHas(
'roles', function ($query) {
$query->where('name', 'user');
})
->with([
'chats' => function ($query) {
$query->orderBy('id', 'DESC');
}])
->paginate(25);
It still shows also the admins.
Any idea why please?
Thank you.
What if you try this:
$users = User::role('user')
->with([
'chats' => function ($query) {
$query->orderBy('id', 'DESC');
}])
->paginate(25);
->get()
these are the docs for the basic usage of the package https://spatie.be/docs/laravel-permission/v5/basic-usage/basic-usage
@Nakov I am confused about why you use get() after paginate()?
@Nakov I tried your solution(thank you).
When doing this on the first request it works:
$users = User::role('user')
But as soon as I do this(search bar).
$users = User::role('user')
->when($search, function ($query) use ($search) {
$query->where('email', 'LIKE', "%{$search}%");
})
->paginate(25);
I am getting all the admins with the results. It looks like the when() close is causing problems.
@User1980 why do you have a group by? Seems out of place. Does it work without it?
Otherwise check the actual query made using debugbar or clockwork
@User1980 copy-paste error, sorry. It should be without ->get().
@Sinnbeck The problem got resolved when I added: ->role('user')
At the end of the query (before the paginate).
@User1980 I see you don't need help in the future...
It's useless to help you.
@MichalOravec I am not sure I understand....
Whats the point of groupBy on a list of unique ids
@Snapey That was a copy/paste mistake. I corrected it thank you.
Please or to participate in this conversation.