Вячеслав Беликов

SELECT
t1.email AS email,
parent.email AS parent_email,
t1.password AS password
FROM my_table t1
INNER JOIN my_table parent ON t1.parrent_id = parent.id
ORDER BY t1.email