Self Join

SQL SELF JOIN

A table can be joined to itself in a self-join.

SELECT column_name(s)
FROM A_table, B_table
WHERE A_table.column_name = B_table.column_name;

SELECT b.*
FROM Test a, Test b 
WHERE a.id = b.parent_id
ORDER BY a.id ;