SELECT
sc.synopsis_fk,
'characters',
JSON_ARRAYAGG(c.name)
FROM synopsis_characters sc
USE INDEX (idx_character_order)
INNER JOIN characters c
ON sc.character_fk = c.id
GROUP BY
sc.synopsis_fk
SELECT
sc.synopsis_fk,
'characters',
JSON_ARRAYAGG(c.name)
FROM synopsis_characters sc
USE INDEX (idx_character_order)
INNER JOIN characters c
ON sc.character_fk = c.id
GROUP BY
sc.synopsis_fk