Each user profile has its own VPN, with its own configuration. For all intents and purposes, in this aspect, you can think of each user profile as a separate phone. You need to install a VPN app or otherwise configure your VPN on each user profile you use.
This has the added benefit of allowing you to use different VPNs/servers to diversify your traffic per profile.