mysql 查找重复数据

select * from user_member
where uid in (select  uid  from  user_member  group  by  uid  having  count(uid) > 1)