In https://gitlab.com/gitlab-com/gl-infra/production/-/issues/3894, we
found that query plans using `base_and_descendants` as a subquery in an
`IN ()` clause may trigger a PostgreSQL v11 query planner bug, resulting
in a significant performance degradation.

https://gitlab.com/gitlab-org/gitlab/-/merge_requests/56078 works around
this issue by moving the clause into a INNER JOIN, but finders may have
to take advantage of this by calling `Group#all_projects` instead of
`base_and_descendants`.

This is a similar fix to
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/56346.

Relates to https://gitlab.com/gitlab-org/gitlab/-/issues/324220