Resolve "Unable to view projects pending deletion from subgroup"

What does this MR do and why?

This MR fixes the issue where projects in subgroups of paid groups that are deleted, do not appear in the pending deletion tab.

The cause of the issue is the fact that we only considered root groups as the paying groups, while subgroups of a paid root group can also be considered as a paid group. We should take this into consideration.

More details of the fix is available in #398694 (comment 1328990229).

Screenshots or screen recordings

Before (project in subgroup does not appear)	After

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.

Related to #398694 (closed)