SELECT `CUR`.`Category_Id` AS CID, `CUR`.`Category_Name` AS CNAME, `PAR`.`Category_Id` AS PID, `PAR`.`Category_Name` AS PNAME FROM `BWS_CATEGORY` AS `CUR` LEFT JOIN `BWS_CATEGORY` AS `PAR` ON `CUR`.`Parent_Category_Id` = `PAR`.`Category_Id` WHERE `CUR`.`Category_Id` = '90915'