I am able to drill down only to one level.

I used the following query:

SELECT c1.categoryid as ParentCategoryID, c2.categoryid as SubCategoryID, c1.categoryname AS ParentCategory, c2.categoryname AS SubCatgeory

FROM category AS c1 INNER...