Concat IDs into a single field in SQL

Here is how to merge multiple SQL rows into one, values separated by a comma.

Do it like this:

SELECT GROUP_CONCAT(id SEPARATOR ', ') FROM `table_name` WHERE `is_active`=1