SELECT
    `class_categories_lang`.*
    , `class_categories_lang_1`.`name`
FROM
    `standin_old`.`class_categories_lang`
    INNER JOIN `standin_old`.`class_categories` 
        ON (`class_categories_lang`.`id` = `class_categories`.`id`)
    INNER JOIN `standin_old`.`class_categories_lang` AS `class_categories_lang_1`
        ON (`class_categories`.`parent_id` = `class_categories_lang_1`.`id`)
WHERE (`class_categories_lang`.`lang_id` = 'ru');

SELECT
    `class_categories_lang`.*
    , `class_categories_lang_1`.`name` AS `parent`
FROM
    `standin_old`.`class_categories_lang`
    INNER JOIN `standin_old`.`class_categories` 
        ON (`class_categories_lang`.`id` = `class_categories`.`id`)
    INNER JOIN `standin_old`.`class_categories_lang` AS `class_categories_lang_1`
        ON (`class_categories`.`parent_id` = `class_categories_lang_1`.`id` AND `class_categories_lang_1`.`lang_id` = 'ru')
WHERE (`class_categories_lang`.`lang_id` = 'ru');