Mysql 在 JSON_ARRAYAGG 函数上用 order by 不生效 ，怎么办 ？

Question

SELECT
    JSON_ARRAYAGG( JSON_OBJECT( 'name', NAME ) )
FROM
    student 
ORDER BY
    id  

Answer 1

   SELECT
       JSON_ARRAYAGG(
           JSON_OBJECT('name', name)
           ORDER BY id ASC
       )
   FROM
       student;