SELECT Y.F_CODES,GROUP_CONCAT(X.F_NAME) AS INFONAMES
FROM T_INFO_TYPE X
JOIN T_INFO Y ON FIND_IN_SET(X.F_CODE,Y.F_CODES) > 0
GROUP BY Y.F_CODES
GROUP_CONCAT参考:MySql之GROUP_CONCAT函数拼接换行符GROUP_CONCAT(拼接字段 SEPARATOR ‘<;br/>;‘)_mysql拼接换行符_小矶鹬的博客-CSDN博客
FIND_IN_SET参考: MYSQL中 find_in_set() 函数用法详解_孔子-说的博客-CSDN博客