[SELECT `cat0`.`id` AS `cat_0_id`,`cat1`.`id` AS `cat_1_id`,`cat2`.`id` AS `cat_2_id`,`cat3`.`id` AS `cat_3_id` FROM `categories` AS `cat0`  LEFT JOIN (`categories` AS `cat1`) ON `cat0`.`parent_id` = `cat1`.`id`  LEFT JOIN (`categories` AS `cat2`) ON `cat1`.`parent_id` = `cat2`.`id`  LEFT JOIN (`categories` AS `cat3`) ON `cat2`.`parent_id` = `cat3`.`id` WHERE `cat0`.`id` = ]x