select max(id) id,nickname,tel,`group`,ali_pid,ad_pid,pid from 表名 group by nickname,tel,`group`,ali_pid,ad_pid,pid
