[PHP] recursive queries-tree view implementation

I am sure others have encountered this so I am just looking for ideas. Say I have an ancestry application where the users can enter parents, children, etc. The children have children, etc. table people id parent_id what is the best way to pull this from the db minimizing the number

RE: [PHP] recursive queries-tree view implementation

Say I have an ancestry application where the users can enter parents, children, etc. The children have children, etc. table people id parent_id what is the best way to pull this from the db minimizing the number of queries to build a tree view of parents to children?