select id,member_id,type from visits where type = 1 group by member_id having count(*) >2;
统计数据表中某个字段的值大于2条的数据
原文：https://www.cnblogs.com/qxandxt/p/11106100.html
