• WITH n(id, name) AS

    (SELECT id, name

    FROM tulieu

    WHERE parent = 44

    UNION ALL

    SELECT m.id, m.name

    FROM tulieu as m, n

    WHERE n.id = m.parent)

    SELECT * FROM n