category with parentid

[HaidarPesebe]

I have a database for the category

id | name   | parentid
----------------------
1 | cat A      | 0
2 | cat B      | 0
3 | subcat A | 1
4 | subcat A | 1
5 | subncat B | 2
-------------------------

I want to display the result like this:

1. Cat A
      - Subcat A
      - Subcat A
2. CatB
      - Subcat B

ask for help for this.
Thanks for the help



__________ Information from ESET NOD32 Antivirus, version of virus signature database 7165
(20120524) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com