mysql sql拼接

两个字段sql拼接在一起

select a.id,a.order_name,a.order_time,a.provider_name,CONCAT_WS('',b.`name`,b.suffix)as `name`
        from service_provider a LEFT JOIN district b on a.district_id = b.`code`