I've been married for almost four years. I'm finishing my first year in a Social PhD program.
Overall, I'd say me being in a PhD program has been a net positive for our marriage. We live in different (nearby) states, so I tend to come home every other weekend, but it's not impossible to drive over, stay one night, and come back the next morning, midweek.
My wife just started work last fall as a corporate attorney, so she's very busy most of the time anyway. When we're together, we may just be having takeout between sessions of me studying and her working (including on weekends). Both of us are career-driven, so the relationship works.
If you have a family that accepts the idea that "school comes first" then things tend to go a bit smoother. My wife appreciates the demands that grad school can place on a person, just as I accepted it for her when she was in law school. It also helps that there are no children in the picture
It's also good if your spouse can share your enthusiasm about being a grad student and what you're studying/researching. If psych bores them, you lose a potential shared interest. I like the law and my wife likes psychology, so we can both "talk shop" without the other one's eyes glazing over. This definitely helps!