mysql一对多查询

mysql一对多查询使用 group_concat() 函数：

SELECT
t_material_mart.title,
(SELECT group_concat(t_recommend_menu_second.menu_name) 
	FROM t_recommend_menu_second 
	INNER JOIN t_material_project ON t_material_project.project_sort_id = t_recommend_menu_second.id 
	WHERE t_material_mart.id = t_material_project.material_mart_id
) as type
FROM
t_material_mart