How to build menu with single query?

[eluser]umefarooq[/eluser]
How can we make n level tree or menu with just single query, no need to call SQL query in loop to get its children, just get everything with one query and make tree or menu out of it, anybody know any good library,code or helpers please share, will help all CI community.