废话少说直接开始玩一下 SELECT user_id,count(*) FROM ts_order GROUP BY ts_order.user_id HAVING count(user_id)>1; 执行效果展示: