GROUP_CONCAT

select cart_id
from (select cart_id, GROUP_CONCAT(name) name
    from cart_products
    group by cart_id) a
where name like '%Yogurt%' and name like '%Milk%'
order by cart_id

cart_id 별로 name을 전부 잇기