1 2 3 4 5 6 |
$productId = 5; $query = Products::SELECT('products.id','products.name','categories.name') ->leftJoin('categories', function($query) use($productId) { $query->on('products.category_id','=','categories.id') ->where('products.category_id', '=', $productId); })->get(); |