MySQL与Group By的一对多连接仅返回一个观察

I have a comment table and a tag table. For each comment, there could be multiple tags, or none. I want to join the two so I can get a list of tags for each comment. I have a comment table and a tag table. For eac