Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
I have 3 columns "users", "roles" and "role_user", where the user role has 3 columns, admin(1), staff(2), and client(3) if I want to display users according to their roles how am I to go about it
client controller page
public function index(){
return view('admin.clients.index',[
'role' => Role::find(3)
]);
}
client.index page
@foreach ( $role as $user )
I have 3 columns "users", "roles" and "role_user"
sure? You should have 3 tables ...
the user role has 3 columns,
sure ? It should have 3 records ...
Then follow the doc example (by finding role)
foreach ($role->users as $user) {
https://laravel.com/docs/9.x/eloquent-relationships#retrieving-intermediate-table-columns
@sr57 thank you
You should be calling $user not $role in your foreach, since you have assigned $role to $user. Plus you will have multiple users per role. You're only returning 1 role, no need to loop through the single role, but rather the users attached to that role.
{{ $role->name }}
@foreach($role->users as $user)
{{ $user->name }}
{{ $user->email }}
@endforeach
Assuming you've called the relationship method users()
@RayC thank you
Please or to participate in this conversation.