MySQL nested queries how to select more than one row
===

SELECT id, FIO, parent_id FROM users WHERE parent_id = (SELECT id FROM users WHERE parent_id = (SELECT id FROM users WHERE id = 16))

so here i am making an hierarchy tree, first selecting the root parent, then the childrens an so on to 24 level of depth


the question is: how to select more than one row?

because i need to get the other rows fields to display info like: name, surname, age

it looks like i can only get those rows in the last query(the most top)

ps: i don't want to use joins because they generate duplicate fields

is there a solution?