Oh I'm well aware that teachers can and do have affairs- I am also a primary school teacher, and at my last school, three of the four male teachers were married. Each and every one of them had an affair with at least one female member of staff.
One of them slept with two different teachers: the first one was married herself; the second one (the deputy head), his wife found out and left him, so he moved straight in with her.
One of the others cheated on his wife (a teacher at another school) with her TA, who then trained to be a teacher and came to work at our school. They were together for a few years until he cheated on her with a TA at our school. He was SLT, so above both of these women in the school hierarchy. The head told him that she couldn't fire him, but that he had to leave.
The one male member of staff who was single slept with three different female teachers, one of whom was married, another of whom was living with her long-term boyfriend.
This school had a real culture of nights out and staff parties, though, whereas my wife is almost always home by 5pm! (We have a 2 year old, so she prioritises spending time with her.)
In the off-chance anyone reading this worked at this same school, it's very outing, but felt quite cathartic to get that off my chest! It was and is a lovely school, but lots of toxicity among the staff.