Mysql Get child table data as json in same row

query.sql

SELECT a.id, a.product_name, a.pdf_url, 
JSON_ARRAYAGG(
  JSON_OBJECT(
    'id', c.id,
    'name', c.name
  )
) AS tag
FROM products a 
LEFT JOIN product_tags b ON (a.id = b.product_id)
LEFT JOIN tags c ON (b.tag_id = c.id)
GROUP BY a.id