set @j=‘[{"xx":"bb","reviews":[]},{"bb"}]‘;

set @j=json_array_append(@j,‘$[0].reviews,json_object("aa","vvv"));

------------------------------------

[{"xx":"bb","reviews":[{"aa":"vvv"}]},{"bb"}]

mysql json