Nested Categories over Drop Down

Parentselect * from categories where parentId='0'category1select * from categories where parentId='1'          category1.1select * from categories where parentId='5'                    category1.1.1select * from categories where parentId='7'                    category1.1.2select * from categories where parentId='8'                              category1.1.2.1select * from categories where parentId='12'                    category1.13select * from categories where parentId='9'          category1.2select * from categories where parentId='6'category2select * from categories where parentId='2'          category2.1select * from categories where parentId='10'          category2.2select * from categories where parentId='11'category3select * from categories where parentId='3'category4select * from categories where parentId='4'

Nested Categories over List

• category1
  • category1.1
    • category1.1.1
    • category1.1.2
      • category1.1.2.1
    • category1.13
  • category1.2
• category2
  • category2.1
  • category2.2
• category3
• category4

BreadCrumb

category1 » category1.1 » category1.1.2 » category1.1.2.1