Self joining tables

[Edward Mostrom]

How would you do a select in empire-db where a table joins to itself.

select p.name, c.name from person p join person c on c.parent_id = p.id
where p.status = 1
and c.status < 5