`reflect_auto_register_static` doesn't register types in crates that aren't part of the workspace

## Bevy version and features

- bevy 0.17.2
- `reflect_auto_register_static` feature

## What you did

Using `reflect_auto_register_static` feature to automatically register types where `reflect_auto_register` doesn't work.

## What went wrong

Only types from the current workspace get registered, anything in dependencies (`bevy_reflect`, `bevy_ecs`, `bevy_transform`, etc.) doesn't.

## Additional information
Found by @occuros [on discord](https://discord.com/channels/691052431525675048/1374187654425481266/1424918071251832953)

Repro: https://github.com/occuros/bevy_0_17_type_registry

---

This is because `reflect_auto_register_static` doesn't take into account where it's invoked, so the `target` where it writes the registration functions to is different from the one where the `load_type_registrations!` macro looks for them when compiled for crates outside the current workspace.