Laravel 5.3 withCount() nested relation

by

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:

More Related Contents:

  1. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  2. Automatically deleting related rows in Laravel (Eloquent ORM)
  3. Get Specific Columns Using “With()” Function in Laravel Eloquent
  4. How do I get the query builder to output its raw SQL query as a string?
  5. How to do this in Laravel, subquery where in
  6. Laravel Eloquent Query Using WHERE with OR AND OR?
  7. Laravel Check If Related Model Exists
  8. Laravel update model with unique validation rule for attribute
  9. How can I convert many statement mysql to laravel eloquent?
  10. Eloquent ORM Code Hinting in PhpStorm
  11. Get the Query Executed in Laravel 3/4
  12. How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent?
  13. What does “Mass Assignment” mean in Laravel?
  14. Laravel OrderBy relationship count
  15. Laravel Checking If a Record Exists
  16. How to add some textfield in form register (laravel generator infyom)?
  17. How to set a default attribute value for a Laravel / Eloquent model?
  18. Laravel 5 hasMany relationship on two columns
  19. Laravel – Database, Table and Column Naming Conventions?
  20. Order By before Group By using Eloquent (Laravel)
  21. Laravel Recursive Relationships
  22. How to Merge Two Eloquent Collections?
  23. Laravel Eloquent – Attach vs Sync
  24. How to create a subquery using Laravel Eloquent?
  25. Eloquent model mass update
  26. Difference between Eloquent\Model::get() and all()
  27. Eloquent many-to-many-to-many – how to load distant relation easily
  28. laravel 5.3 new Auth::routes()
  29. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  30. Laravel Eloquent update just if changes have been made

Leave a Comment