Project Fi let's you do exactly this. You pay for data used, and can have up to 10 sims that use this bucket of data. It's on the pricey side, so it works best

Project Fi let's you do exactly this. You pay for data used, and can have up to 10 sims that use this bucket of data. It's on the pricey side, so it works best if you use wifi a lot.