<select id="getDeptUrl" parameterType="java.lang.String" resultType="com.tianheng.datacenter.system.model.dto.EmployeeDto">
select e.header_url as url, concat_ws('-',d.name,e.name) as deptUser
from wx_employee e
left join wx_dept d = on d.id = e.dept_id
</select>
解释:concat_ws(1,2,3,····);
1:表示以什么连接;
2、3、····:依次往后连接字段
返回结果,如:阿里-马云