How to count relations in laravel

Question

How can I count for example the number of roles for a user?

When I try this:

User::with('roles')->count();

it just counts the number of users.

What I need is to return the number of roles per user. For example:

[ { "id": 2, "name": "user", "roles": 2 }, { "id": 3, "name": "user", "roles": 1 } ]

Joseph Silber · Accepted Answer · 2015-09-22 14:39:13Z

1

Eloquent does not support this out-of-the-box.

You can read this great article on how to achieve this:

answered Sep 22, 2015 at 14:39

221k59 gold badges369 silver badges292 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Great article indeed, this method is what I use every time I come across this

Jerodev · Accepted Answer · 2015-09-22 14:42:03Z

If you already have the $user object, you can do the following:

$rolecount = $user->roles()->count();

Or if you are using eager loading you can drop the ( & ) at roles

$rolecount = $user->roles->count();

The OP has a collection of users. Doing this for each user means an extra query for every single user. That's terribly inefficient.