refactor: optimize user query using index

[guqing]

What type of PR is this?

/kind improvement /area core /milestone 2.13.x

What this PR does / why we need it:

使用索引机制优化用户查询以提高性能

Does this PR introduce a user-facing change?

使用索引机制优化用户查询以提高性能

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 75.00000% with 13 lines in your changes are missing coverage. Please review.

Project coverage is 56.82%. Comparing base (5fdf6c0) to head (04834b4). Report is 27 commits behind head on main.

:exclamation: Current head 04834b4 differs from pull request most recent head 9838d95. Consider uploading reports for the commit 9838d95 to get more accurate results

Files	Patch %	Lines
...alo/app/core/extension/endpoint/StatsEndpoint.java	0.00%	10 Missing :warning:
...ain/java/run/halo/app/infra/SchemeInitializer.java	80.00%	2 Missing and 1 partial :warning:

Additional details and impacted files

@@             Coverage Diff              @@
##               main    #5396      +/-   ##
============================================
- Coverage     56.91%   56.82%   -0.09%     
- Complexity     3319     3332      +13     
============================================
  Files           587      588       +1     
  Lines         18968    19043      +75     
  Branches       1401     1396       -5     
============================================
+ Hits          10795    10822      +27     
- Misses         7594     7640      +46     
- Partials        579      581       +2     

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[sonarqubecloud[bot]]

Quality Gate passed

Issues
0 New issues

Measures
0 Security Hotspots
No data about Coverage
0.3% Duplication on New Code

See analysis details on SonarCloud

[f2c-ci-robot[bot]]

[APPROVALNOTIFIER] This PR is APPROVED

This pull-request has been approved by: JohnNiang

The full list of commands accepted by this bot can be found here.

The pull request process is described here

Needs approval from an approver in each of these files:

• ~~OWNERS~~ [JohnNiang]

Approvers can indicate their approval by writing /approve in a comment Approvers can cancel approval by writing /approve cancel in a comment