select catname,catpath,cat_active from category where parentid= order by catname