How to select parent child 'n' th records without recursion in sql?

id | name | parent_id ----+--------------+----------- 1 | Cat |
2 | Fun | 1 3 | LOLCs | 2 4 | Anid | 2 5 | Cla | 1 6 | Rena | 5 ................................. Up to 'N' th Level

Pls help me...