select dept_no,GROUP_CONCAT(emp_no order by emp_no separator ',') as employees 
from dept_emp group by dept_no order by dept_no;

运用的是分组合并函数:group_concat