Сослан Алдатов

$ids = [1,2,3,4,5,6];
$query->select('product.id, product.name, product_id, 
COUNT(CASE WHEN product_ingredient.ingredient_id IN ('.implode(",", $ids).') 
THEN 1 END) AS ing_count');