Depends on their age. Where I live, it is legal for a 16 year old to buy wine. So they would also be able to buy sangria. Younger kids can't buy alcohol.
I would just mix the wine weaker for them in it, depending on their age.
you can substitute wine with apple cider but thats no fun.
if it doesn't have alcohol in it i don't see why not