query to list tables according to relationship

[jonny quest]

what is the query to list all tables in a schema with relation?

for example:
schema_name
table1
id
name
table2_id
table2
id
name
table3
id
name
table2_id

so that the result arrangement is : table2, table1 then table3 or table2, table3 then table1