@theo This is a good use case for entity management. You can model workspaces as entities and then grant a single user account permissions for each workspace as needed.
This is a slightly different model, because the user still has one account, though.
Here's more details: https://fusionauth.io/docs/v1/tech/core-concepts/entity-management
Note that entity management is a feature requiring a paid license.