Enhancement: Merge multiple ResultIterator objects into one

[charlesc-ai]

Question: how to merge 3 User[]|ResultIterator ? without breaking the object structure?
Pagination and sort issues should be considered.

Example:
$usersGroup1 = $this->userDao->getAvailableCaptains();
$usersGroup2 = $this->userDao->getAvailableCoCaptains();
$usersGroup3 = $this->userDao->getAvailableTrainees();

Target: merge into 1 usersGroup, return for GraphQL usage

Current solution:

1. (better choice) Create one SQL query instead of 3
2. If the results are relatively small without pagination, we can do "$usersGroup1->toArray()" then array_merge() with other arrays, then finally return an array of merged User[].