Query Mysql

SELECT
  CONCAT(SUBSTRING(no_intern, 1, 2 * 1),
  MAX(SUBSTRING(no_intern, (2 * 2) -1, 2))
  ) AS menu
FROM tb_m_menu
WHERE no_intern LIKE (SELECT CONCAT(SUBSTRING(no_intern, 1, 2 * level_menu), '%') FROM tb_m_menu WHERE id_menu = 1)

/* Jika saya ubah jadi seperti dibawah ini: */

SELECT
  CONCAT(SUBSTRING(no_intern, 1, 2 * 1),
  MAX(SUBSTRING(no_intern, (2 * 2) -1, 2))+1 /*ditambahkan 1*/
  ) AS menu
FROM tb_m_menu
WHERE no_intern LIKE (SELECT CONCAT(SUBSTRING(no_intern, 1, 2 * level_menu), '%') FROM tb_m_menu WHERE id_menu = 1)