I changed the user permission from company manager to manager and now they cannot see any workspaces

When you demote a company manager to a manager, the user will not have access to any workspaces.  You will need to add the user to each workspace you would like to give them access to.