How to properly concatenate strings in SQL?

Question

MySQL

There is a query in the database of the form

SELECT 
users.name AS users_name, 
users.uid AS uid, 
users.created AS users_created,
domain_editor.domain_id AS domain_editor_domain_id, 
'user' AS field_data_field_user_statut_user_entity_type

FROM 
users

LEFT JOIN  domain_editor ON users.uid = domain_editor.uid
WHERE (( (users.status <> '0') ))
ORDER BY users_created DESC
LIMIT 10 OFFSET 0

Which at the output gives such a result

. That is, the same user with different domain id is shown 3 times.
The client wants the user to be shown only once and the domain id is separated by commas.
The question is how to implement it correctly?
Tried to use something like

GROUP_CONCAT(DISTINCT domain_editor.domain_id ORDER BY domain_editor.domain_id ASC SEPARATOR ',')

But alas, I can't get the right result in the end.

Answer 1

In group by list all fields except domain_id.

select 
users.name AS users_name, 
users.uid AS uid, 
users.created AS users_created,
GROUP_CONCAT(DISTINCT domain_editor.domain_id ORDER BY domain_editor.domain_id ASC SEPARATOR ',') AS domain_editor_domain_id_concated, 
'user' AS field_data_field_user_statut_user_entity_type
...
group by users_name, uid, users_created, field_data_field_user_statut_user_entity_type