feat: support pod based prometheus discovery

[aylei]

What type of PR is this?

• [ ] API-change
• [ ] BUG
• [ ] Improvement
• [ ] Documentation
• [x] Feature
• [ ] Test and CI
• [ ] Code Refactoring

Which issue(s) this PR fixes:

This feature will help address https://github.com/matrixorigin/MO-Cloud/issues/3106

What this PR does / why we need it:

Not Available

Special notes for your reviewer:

Not Available

Additional documentation (e.g. design docs, usage docs, etc.):

Not Available