select `id`, group_concat(`name` separator " | ") from `books` group by `author_id`