Do it like this:
SELECT GROUP_CONCAT(id SEPARATOR ', ') FROM `table_name` WHERE `is_active`=1
Here is how to merge multiple SQL rows into one, values separated by a comma.
SNP 012 #951 Filed
Do it like this:
SELECT GROUP_CONCAT(id SEPARATOR ', ') FROM `table_name` WHERE `is_active`=1