MySQL 查询，拼接html代码

//mysql查询，拼接html代码    
SELECT 
    '<table class="htmlStr" id="htmlStr" >' AS htmlStr
UNION ALL
	SELECT '<tr id="thead"><th style="width:10%">ID</th><th style="width:20%">片区</th><th style="width:20%">客户</th></tr>' AS htmlStr
UNION ALL
		(
			SELECT
				concat(
					'<tr class="children_"><td align="center">',
					c.id,
					'</td><td align="center">',
					ifnull(d.area_name, "无"),
					'</td><td align="center">',
					ifnull(c.institution_name, ""),
					'</td></tr>'
				) AS htmlStr
			FROM
				t_customer2_list2 c
			LEFT JOIN t_sales2_area2_set2 d ON c.area = d.id
			WHERE
				1 = 1
			LIMIT 0,
			30
		)
UNION ALL
    SELECT	'</table>' AS htmlStr;