How to use Laravel eager loading on model that belongsTo same class

Question

I have following code:

In a Category Model

public function posts()
{
  return $this->belongsToMany(Post::class, 'post__post_category_relations', 'category_id');
}

public function children()
{
  return $this->hasMany(Category::class, 'parent_id');
}

In a Category Controller:

public function index(Category $category){
  $category_childrens = $category->children;
  $posts = ???;
  return view('show.posts',compact('posts'));
}

I am trying to retrieve the $posts associated with $category_childrens and pass them to my view.

AFAIK, if you have setup the relationships, it should automatically pull the respective data from the tables when you query the model. — Script47, May 30 '18 at 01:44
Possible duplicate of [How can I join with Eloquent: Relationships? (Laravel 5.3)](https://stackoverflow.com/questions/42641789/how-can-i-join-with-eloquent-relationships-laravel-5-3) — Script47, May 30 '18 at 01:45
Check the duplicate I have linked, you should be able to use `with` from what I can tell. Be sure to up-vote both the question and answer if it helps. — Script47, May 30 '18 at 01:47
@user1491032 Sorry, I want join posts of each $category_children! — justcntt, May 30 '18 at 02:04
`$posts = $category_childrens->get()->load('posts')` or `$posts = $category_childrens->with('posts')` — lufc, May 30 '18 at 02:08

score 0 · Accepted Answer · answered May 30 '18 at 03:06

I found solution in here:

Laravel get all products from infinity nested categories

My script:

In a Category Model:

public static function getAllPosts($category, $posts = null)
{
    if ($posts == null) {
        $posts = collect();
    }
    $posts = $posts->merge($category->posts);

    foreach($category->children as $child){
        $posts = self::getAllPosts($child, $posts);
    }

    return $posts;
}

In a Controller:

....
$category = $this->category->findBySlug($_GET['category_name']);

$posts = Category::getAllPosts($category);

return view('post::admin.posts.index', compact('posts','category','categories'));

How to use Laravel eager loading on model that belongsTo same class

1 Answers1