SELECT
    `a`.`id` AS `id`,
    `a`.`code` AS `code`,
    `a`.`created_time` AS `created_time`,
    `a`.`display_order` AS `display_order`,
    `a`.`index_tree` AS `index_tree`,
    `a`.`last_updated_time` AS `LASTMODIFIED`,
    `a`.`level` AS `level`,
    `a`.`name` AS `name`,
    `a`.`permission_config` AS `permission_config`,
    `a`.`permission_type` AS `permission_type`,
    `a`.`status` AS `status`,
    `a`.`total_member` AS `total_member`,
    `a`.`organization_id` AS `organization_id`,
    `a`.`parent_id` AS `parent_id`,
    `a`.`organization_id` AS `domainId`
FROM
    `tenant_departments` `a`