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();
|