Cells: Fix cross joins related to groups

Fix the cross joins in these files:

• app/models/group.rb:699:
• [-] ee/app/models/ee/group.rb:770: => #417464 (closed)
• [-] lib/gitlab/group_search_results.rb:16: => #427108 (closed)

Refer to the epic for more information about this. Feel free to:

1. Copy the epic description to this issue to helper the reviewers understand the problem.
2. Split this issue into different issues in case it was so much effort to
3. Ask for help and hints on #tenant-scale on how to fix cross joins