一个sql

一个小功能，sql里面用到了一些玩法，记录一下~

SELECT
    id,
    code,
    path,
    (1) AS type
FROM
    department
WHERE
    path LIKE CONCAT(
        (
            SELECT
                path
            FROM
                department
            WHERE
                id = '1'
        ),
        '%'
    )
UNION
    (
        SELECT
            id,
            code,
            path,
            (2) AS type
        FROM
            department
        WHERE
            path REGEXP (
                (
                    SELECT
                        group_concat(path SEPARATOR '|')
                    FROM
                        department
                    WHERE
                        id IN (
                            SELECT
                                id_to
                            FROM
                                charge_relation
                            WHERE
                                type_from = '1'
                            AND id_from = '2c94978a69b2a9ee0169c7bd198b0449'
                            AND type_to = '2'
                            AND charge_type = '3'
                        )
                )
            )
    )