Selecting data from database as json

gistfile1.txt

SELECT CONCAT(
    '[', 
       GROUP_CONCAT(JSON_OBJECT(
         'id', id, 
         'name', name,
         'color', color,
         'background_color', background_color,
         'drag_background_color', drag_background_color,
         'border_color', border_color,
         'deleted', deleted
       )),
    ']'
) 
FROM my_schedule_calendar;