sql中将其中的某个字段横着显示出来的方法.

场景：因为做电销统计，统计电话号码的每个状态的数量，可是状态都在一列中，想不同的状态都是单独的一列。

SELECT
			pi.import_code,
			pi.import_sum,
			pi.import_actual_sum,
			pi.import_time,
			sum(pp.count) as fp_num,
			CONCAT(sum(if(pp.phone_status=0,pp.count,0)),'(',CAST(ROUND(sum(if(pp.phone_status=0,pp.count,0))/sum(pp.count)*100,2) AS CHAR),'%)') as status0,
			CONCAT(sum(if(pp.phone_status=1,pp.count,0)),'(',CAST(ROUND(sum(if(pp.phone_status=1,pp.count,0))/sum(pp.count)*100,2) AS CHAR),'%)') as status1,
			CONCAT(sum(if(pp.phone_status=2,pp.count,0)),'(',CAST(ROUND(sum(if(pp.phone_status=2,pp.count,0))/sum(pp.count)*100,2) AS CHAR),'%)') as status2,
			CONCAT(sum(if(pp.phone_status=3,pp.count,0)),'(',CAST(ROUND(sum(if(pp.phone_status=3,pp.count,0))/sum(pp.count)*100,2) AS CHAR),'%)') as status3,
			CONCAT(sum(if(pp.phone_status=4,pp.count,0)),'(',CAST(ROUN