select a.categoryName as '父栏目',b.categoryName as '子栏目' from `category`as a, `category`as b where a.categoryid=b.pid