SELECT CONCAT('"', GROUP_CONCAT(unsubemail.unsubemail separator '","'), '"')
FROM `unsubemail`
left join unsubemail_reason ON unsubemail_reason.reason_id=unsubemail.reason
where reason<>6 and unsubemail.unsubemail not like '%@aiacademy.tw' and unsubemail.unsubemail not in ('aaa@lll.com','test@test.com','vansindata@gmail.com')
ORDER BY `reason_id`,unsubemail.unsubemail DESC