set countt = PAGE_ * 5 - 5;
set @data = (select JSON_ARRAYAGG(JSON_OBJECT('id',room_participants.id,'isAdmin',room_participants.isAdmin,'userId',room_participants.userId,'joinTime',room_participants.joinTime,'leftTime',room_participants.leftTime,'status',room_participants.status,'kickTime',room_participants.kickTime,'displayName',users.displayName,'phone',users.phone,'created',created))
from room_participants
LEFT JOIN users ON room_participants.userId = users.id
WHERE room_participants.roomId = ROOMID_ LIMIT 5 OFFSET countt);
我需要上面的查询以json_arrayagg格式仅显示5个数据,但返回的整个数据却不限制为5。我的查询出了什么问题?