wulan.sql

SELECT
    p.nama AS 'NAMA PEGAWAI',
    (
    SELECT
        m.nama
    FROM
        pegawai AS m
    WHERE
        m.id_pegawai = p.id_manager
) AS 'NAMA MANAGER'
FROM
    `pegawai` AS p
WHERE
    EXISTS(
    SELECT
        1
    FROM
        pegawai AS m
    WHERE
        m.id_pegawai = p.id_manager
) ORDER BY
    p.id_manager ASC;