When there are many users, a large select query can cause the database to crash, so it needs to be split into paginated API requests to handle it.

[jinleileiking]