Refactor how zoekt_nodes are determined for zoekt_searchable_scope

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

In ee/app/services/concerns/search/zoekt_searchable.rb, zoekt nodes have to be gathered through a few database calls. This could be refactored a bit The following discussion from !140252 (merged) should be addressed:

Edited by 🤖 GitLab Bot 🤖