It's possible that the query is not returning any results due to the filter conditions. Here are a few things you can try to troubleshoot the issue:
1. Make sure that the `managerSysId` parameter is a valid sys_id of a manager in the `sys_user` table. You can verify this by checking the `sys_user` table directly.
2. Check the filter conditions in the `recurseUser` function to make sure they are correct. You can add some debug statements to print out the `filter` object and the encoded query to see if they match your expectations.
3. Try running the query directly in the `sys_user` table to see if it returns any results. This can help you identify any issues with the query conditions.
4. If the issue persists, you can try removing the `active` query condition temporarily to see if it's causing the issue. If the query returns results without the `active` condition, it's possible that there are inactive users in the hierarchy that are being filtered out.
I hope this helps you troubleshoot the issue. Let me know if you have any further questions!