LaravelDaily/Eloquent-OrderBy-Relationship

class ProductController extends Controller
{
    public function index()
    {
        // The most performant way to order by relationship field is to use join()
        $products = Product::select(['products.*', 'categories.name as category_name'])
            ->join('categories', 'products.category_id', '=', 'categories.id')
            ->orderBy('categories.name')
            ->paginate(100);
 
        return view('products.index', compact('products'));
    }
}