Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
In my project I have a users table, a roles table and a pivot table role_user, which defines which is the role of every user. Of course there are corresponding models, User and Role. Now, I would like to have a Client model, which will load only the users that have the role of Client. (role_id = 4). Is that possible and how can I do it?
Why not just add a scope?
User::clients()->get();
//on model
public function scopeClients($query)
{
return $query->whereHas('role', function (Builder $subquery) {
$subquery->where('role'_id, 4);
});
}
Thank you, @sinnbeck. That seems like a good idea. I thought it would be nice to use Client::whatever_function when referring to clients. Is that possible with scope?
@andyz Kinda yeah. You can add create a client model, and add a global scope to it
https://laravel.com/docs/8.x/eloquent#applying-global-scopes
@Sinnbeck It must be the solution I needed. Thank you!
@Sinnbeck I still have a problem and would much appreciate some more help. I created a ClientScope and in the apply() method added:
$builder->whereHas('roles', function(Builder $subquery){
$subquery->where('role_id', 4);
});
but when I call Client::all() the query is wrong, because instead of looking for user_role table, its is looking for client_role. The query is
select * from `users` where exists (select * from `roles` inner join `client_role` on `roles`.`id` = `client_role`.`role_id` where `users`.`id` = `client_role`.`client_id` and `role_id` = 4))
Any idea on how I can fix that?
@andyz So it should just be this I would assume
$builder->whereHas('roles', function(Builder $subquery){
$subquery->where('roles.id', 4);
});
Or you can just add your own join
$builder->join('client_roles', function($join){
$join->on('users.id', '=', 'client_role.user_id')->where('client_role.role_id', 4);
});
Oh yeah, one last thing. Consider not extending User. Instead I would use traits for shared methods.
@Sinnbeck That was it! In fact the whole function is
public function apply (Builder $builder, Model $model)
{
$builder->join('role_user', function($join){
$join->on('users.id', '=', 'role_user.user_id')
->where('role_user.role_id', 4);
});
}
Thanks for saving!
@andyz happy to help
Please or to participate in this conversation.