[SOLVED] Sementara

SELECT
  CONCAT(SUBSTRING(no_intern, 1, 2 * 1),
  CONCAT(REPEAT('0', 2-LENGTH(MAX(SUBSTRING(no_intern, (2 * 2) -1, 2))+1)), MAX(SUBSTRING(no_intern, (2 * 2) -1, 2))+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)