$subCategories = Subcategory::join('categories', 'subcategories.category_id', '=', 'categories.id') ->select('subcategories.*', 'categories.name AS cname') ->orderBy('id', 'desc') ->get();