Laravel 5.3 withCount() nested relation

Question

The model structure is as follows

Tutorial -> (hasMany) Chapters -> (hasMany) videos

How can we load number of videos (video_count) from Tutorial Model with laravel 5.3's withCount() method

I have tried:

Tutorial::withCount('chapters')
->withCount('chapters.videos') // this gives error: Call to undefined method Illuminate\Database\Query\Builder::chapters.videos()
->all();

Edit

This works, Any Better solution?

Tutorial::withCount('chapters')
->with(['chapters' => function($query){
    $query->withCount('videos');
}])
->all();

You only need to do one ->withCount('chapters.videos'). Also, make sure your relationships are set properly. — user908157
– user908157, Commented Sep 22, 2016 at 15:22
@DigitalFire Relationships are correct as i can load them with eager loading. just count doesn't populates with withCount() method — Sahil Deliwala
– Sahil Deliwala, Commented Sep 23, 2016 at 5:49
Please post your edit in answers section. I just prefer to do that. — Maulik
– Maulik, Commented Oct 8, 2017 at 9:04

Salman Zafar · Accepted Answer · 2019-11-08 08:17:25Z

66

You can only do a withCount() on a defined relation of the model.

However, a relationship can be hasManyThrough which would achieve what you are after.

class Tutorial extends Model
{
    function chapters()
    {
        return $this->hasMany('App\Chapter');
    }

    function videos()
    {
        return $this->hasManyThrough('App\Video', 'App\Chapter');
    }
}

And then you can do:

Tutorial::withCount(['chapters', 'videos'])

Docs:

https://laravel.com/docs/5.3/eloquent-relationships#has-many-through

edited Nov 8, 2019 at 8:17

Salman Zafar

4,0655 gold badges23 silver badges44 bronze badges

answered Sep 24, 2016 at 22:00

tanerkay

3,9491 gold badge21 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Laravel 5.3 withCount() nested relation

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related