[sql]
SELECT * FROM table as t1
JOIN table2 as t2 ON t2.t1_id = t1.id
JOIN table3 as t3 ON t3.t1_id = t1.id
[/sql]

In this example table2 and table 3 are children of table1 and both have a foreign key field named t1_id