Sorting Children in Laravel : How do I sort children by name?

Question

Below is my controller code

$categories = Category::where('parentId', '=', 0)
                                ->with('children')
                                ->orderBy('name', 'asc')
                                ->get();    
return view('home', compact('categories'));

When I access my categories and its children in the view, the categories seem to be sorted by name but the children categories are not. How do I sort the children categories as well by name?

Also, is it possible to sort the categories using a different criteria than the children eg. By position for categories and name for children. If yes, how?

Answer 1

You need to apply order by on children, not categories. The following code will do the trick:

$categories = Category::whereParentId(0)
  ->with(['children' => function($query) {
    $query->orderBy('name', 'asc');
  }])
  ->get();