借鉴了一下别人的经验用having 少做1个子查询 select * from order_info where user_id in ( select user_id from order_info where product_name in ('C++','Java','Python') and status='completed' and date>'2025-10-15' group by user_id having count(*)>=2 ) and product_name in ('C++','Java','Python') and status='completed' and date>'2025-10-15' order by id;