n Use withCount() to Calculate Child Relationships Records in Laravel | CodimTh

Please Disable Your Browser Adblock Extension for our site and Refresh This Page!

our ads are user friendly, we do not serve popup ads. We serve responsible ads!

Refresh Page
Skip to main content
On . By CodimTh

Use withCount() to Calculate Child Relationships Records

If you have hasMany() relationship, and you want to calculate “children” entries, don’t write a special query. For example, if you have posts and comments on your User model, write this withCount():

public function index()
 $users = User::withCount(['posts', 'comments'])->get();
 return view('users', compact('users'));

And then, in your Blade file, you will access those number with [relationship]_count

@foreach ($users as $user)
 <td>{{ $user->name }}</td>
 <td class="text-center">{{ $user->posts_count }}</td>
 <td class="text-center">{{ $user->comments_count }}</td>


In addition, using the loadCount method, you may load a relationship count after the parent model has already been retrieved:

$book = App\Models\Book::first();


If you need to set additional query constraints on the eager loading query, you may pass an array keyed by the relationships you wish to load. The array values should be Closure instances which receive the query builder instance:

$book->loadCount(['reviews' => function ($query) {
    $query->where('rating', 5);


In addition to the withCount method, Eloquent provides withMinwithMaxwithAvg, and withSum. These methods will place a {relation}_{function}_{column} column on your resulting models. For example:

$posts = App\Models\Post::withSum('comments', 'votes')->get();

foreach ($posts as $post) {
    echo $post->comments_sum_votes;

These additional aggregate operations may also be performed on Eloquent models that have already been retrieved:

$post = App\Models\Post::first();

$post->loadSum('comments', 'votes');



If you would like to eager load a morphTo relationship, as well as nested relationship counts on the various entities that may be returned by that relationship, you may use the with method in combination with the morphTo relationship's morphWithCount method.

In this example, let's assume Photo and Post models may create ActivityFeed models. Additionally, let's assume that Photo models are associated with Tag models, and Post models are associated with Comment models.

Using these model definitions and relationships, we may retrieve ActivityFeed model instances and eager load all parentable models and their respective nested relationship counts:

use Illuminate\Database\Eloquent\Relations\MorphTo;

$activities = ActivityFeed::query()
    ->with(['parentable' => function (MorphTo $morphTo) {
            Photo::class => ['tags'],
            Post::class => ['comments'],

In addition, you may use the loadMorphCount method to eager load all nested relationship counts on the various entities of the polymorphic relation if the ActivityFeed models have already been retrieved:

$activities = ActivityFeed::with('parentable')
    ->loadMorphCount('parentable', [
        Photo::class => ['tags'],
        Post::class => ['comments'],

Riadh Rahmi

Senior Web Developer PHP/Drupal & Laravel

I am a senior web developer, I have experience in planning and developing large scale dynamic web solutions especially in Drupal & Laravel.

Web Posts


Page Facebook