根据指定字段去重

DELETE FROM tongfu_user_statistics
WHERE 1=1
AND `user_id` in (SELECT * FROM ( (SELECT `user_id` `names` FROM tongfu_user_statistics GROUP BY user_id HAVING COUNT(`user_id`)>1) ) a)
AND id not in (SELECT * FROM ( (SELECT MIN(id) ids FROM tongfu_user_statistics GROUP BY user_id HAVING COUNT(`user_id`)>1) ) b)