A ver si esta te sirve para sacar lo que quieres:
Código sql:
Ver originalSELECT tb.USER, tb.password, t1.veces
FROM tb_users tb
INNER JOIN (SELECT password, COUNT( * ) veces
FROM `tb_users`
GROUP BY password HAVING COUNT( * ) >1
)t1 ON tb.password = t1.password
ORDER BY password, USER