Mysql插入编号问题

INSERT INTO itsm_problems(base_id,pro_number)
SELECT 45634,CONCAT('ZH_GD',DATE_FORMAT(NOW(),'%Y'),'-',LPAD(IFNULL(CAST(SUBSTR(MAX(pro_number),11,4) AS SIGNED),0)+1,4,0)) from itsm_problems