CREATE FUNCTION `getSecurityTemplate`(uuid INT) RETURNS text CHARSET utf8 BEGIN DECLARE sTemp text; DECLARE sTempChd text; SET sTemp = ''; SET sTempChd =cast(uuid as CHAR); SELECT group_concat(id) INTO sTemp FROM security_template where pid = sTempChd; IF sTemp THEN SET sTemp = concat(sTempChd,',',sTemp); ELSE SET sTemp = sTempChd; END IF; RETURN sTemp; END