MySQL分组查询，将其它列的数据，合并到一行展示

SELECT
    author_id,
    author_name,
     substring_index( group_concat( DISTINCT task_id ORDER BY task_id ASC ), ',', 3 ) AS taskList 
FROM
    author_info 
GROUP BY
    author_id