我有这样疑问

SELECT
    `mhs`.`nama` AS `nama`,
    `jrs`.`nm_jurusan` AS `nm_jurusan`,
    `mkl`.`matakuliah` AS `matakuliah`,
    `mkl`.`nilai_minimal` AS `minimal`,
    `nilai`.`nilai_mkl` AS `nilai_mkl`,
    `dosen`.`nm_dosen` AS `nm_dosen`
FROM `matakuliah` `mkl`
     INNER JOIN `jurusan` `jrs` ON(`mkl`.`kd_jurusan` = `jrs`.`id`)
     INNER JOIN `mahasiswa` `mhs` ON(`jrs`.`id` = `mhs`.`kd_jurusan`)
     INNER JOIN `dosen` ON(`mkl`.`kd_dosen` = `dosen`.`id`)
     INNER JOIN `nilai` ON (`mkl`.`id` =`nilai`.`kd_mkl`)
ORDER BY
    `jrs`.`nm_jurusan`,
    `mhs`.`nama`,
    `mkl`.`matakuliah`

但输出像

我想要这样的结果

谢谢