Resolve sbom_occurrences cross join issues to organizations

Problem to solve

All cross-joins arising from decomposing gitlab_sec from gitlab_main should be resolved. See parent epic for context.

1. Remove allowed cross-join for relevant relation using associated documentation for guidance on removing cross-joins or cross-transactions occurrences

In the case of sbom_occurrences, we allow-listed cross-joins to the Organization model (example). We should resolve these by batching project IDs or mirroring tables to avoid a cross-DB join.