SELECT email, name
FROM users
GROUP BY email
HAVING count(*) > 1


email name
-------------------
[email protected] aaa
[email protected] bbb
…

こんな感じかな?