I personally would pick BYU if I had those two options for social reasons. You only get one life to live, so choose the place that has a better chance at increasing your testimony and your education.
Cost of living is out of control in Palo Alto, so he'll spend thousands more per year just living there. However, if he likes Stanford better, it's a better school than BYU and could lead to better career opportunities.