[Feature][Manager] Add logically deleted group purging

[woofyzhao]

Description

Add logically deleted group purging to keep control the db size

Use case

DB data size control

Are you willing to submit PR?

• [X] Yes, I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct