delete from member group by username having count(username) > 1
delete from testing.account where id not in (select tmp.id from(select min(id) as id from testing.account group by wechat) tmp);