How more logical to make pagination taking into account groups?

Question

MySQL

I have a query that can have multiple columns in GROUP BY. It is necessary to make pagination, so as not to break the groups. I can't figure out how to approach the issue.
The data should be given in json, and the table is built by js, so I won’t use LinkPager, like DataProviders (I can write my own), but I can’t figure out how to set the limit.
Need a push in the right direction.

Answer 1

I didn't understand either! limit, offset applied to the grouping result