select paypno as 放款计划编号,
group_concat(concat(loano,‘-‘,custname) separator ‘,‘) as ‘订单号-客户姓名‘
from payp_item a
group by paypno
mysql的group_concat函数
原文：http://lavasoft.blog.51cto.com/62575/1956016
