Our code :
$products = \DB::table('products')->leftJoin('product_category as pc', 'pc.product_parent_id', '=', 'products.id')->leftJoin('brand as b', 'b.id', '=', 'products.brand_id')->leftJoin('product_attribute as pa', 'pa.product_parent_id', '=', 'products.id')->leftJoin('attributes as a', 'a.id', '=', 'pa.attribute_id')->leftJoin('products as pro', 'pro.parent_id', '=', 'products.id')->select('products.id as tableproductid','products.name as tableproductname','products.parent_id as tableproductparentid','products.attr_combination as tableproductattr_combination','products.sale_price as tableproductsale_price','products.price as tableproductprice','products.product_image as tableproductproduct_image','products.slug as tableproductslug','products.var_product_image as tableproductvar_product_image','products.availability as tableproductavailability','pc.id as tableproductcategoryid','pc.product_parent_id as tableproductcategoryproductparentid','pc.category_id as tableproductcategorycategoryid','b.id as tablebrandid','b.name as tablebrandname','pa.id as tableproductattributeid','a.id as tableattributeid','a.name as tableattributename','pro.id as tableproductchildrenid','pro.attr_combination as tableproductchildrenattr_combination')->groupBy('products.name')->orderBy('products.id','Desc')->paginate(20);
via user3064563
