MySQL group_concat函数例子

SELECT t_book.id, t_book.chinese_name, t_book.name,
group_concat(t_author.chinese_name separator '/')
from t_book_author
left join t_author on t_author.id = t_book_author.author_id
left join t_book on t_book.id = t_book_author.book_id
group by t_book.id, t_book.chinese_name, t_book.name;