Laravel eloquent get relation count

Question

I use Laravel 5.3.

I have 2 tables :

Articles --------- id cat_id title 

And

Category --------- id parent_id title 

I have defined my relations in my models :

// Article model public function category() {     return $this->belongsTo(Category::class); }  // Category model public function children()  {     return $this->hasMany(Category::class, 'parent_id', 'id'); }    

Is there an easy way using Eloquent to have a list a categories with count of articles. The difficulty is that I want to group categories where id_parent = 0, i.e. I want to display only parent categories with count of articles in children.

I tried something like that :

    $category = new \App\Models\Category();     $categoryTable = $category->getTable();      return $category->leftJoin('article', 'article.cat_id', '=', 'category.id')         ->whereIn('article.cat_id', function($query)             {                 $query->select('cat_id')                     ->from('categories')                     ->where('categories.parent_id', ???)                     ->orWhere($this->tableName .'.cat_id', $id);             })         ->groupBy('cat_id'); 

But I am lost...

Answer 1

you can use withCount(). It is available from 5.3 version

for more info about eloquent visit : https://laravel.com/docs/5.3/eloquent-relationships