How to combine fields into one?

Question

PHP

Hello! I select several records from the database (the number is not known) that have different `name` fields.
Is it possible to get all the `name` fields in one, for example, separated by commas?
type CONCAT(), but CONCAT connects fields that are in the same record.
Here is an example of what I want:

Answer 1

select 1,id,concat_ws(',',name) name from xxx group_by 1;