[json_split_two]cherry pick [Improvement-5880][api] Optimized data structure of pagination query API results (#5895). (#5966)

* cherry pick [Improvement-5880][api] Optimized data structure of pagination query API results (#5895).

* check code style.

* update test class.

* Comment merge adjustment.
Co-authored-by: Nsoreak <60459867+soreak@users.noreply.github.com>