I would consider which secondary school your child is likely to go to. My eldest has just started secondary and moved up with some primary school friends. She would have not liked to have been the only one.
I’m in this situation. None of of our local primary schools have an early enough breakfast club for me to get to work
As a child whose mum worked at my primary school, I hated it. I vowed I would never do that to my child. The expectation on me was so much higher; it was completely unfair. My mum would know at the slightest behavioural hiccup, whereas other children would have to do something really bad for parents to be contafted. Where I work now, the students whose parents work at the school, seem to get away with lots more and know how to beat the system. I would try to avoid it, if possible.
Personally, as a former headteacher I would try to avoid it if I could. It becomes really tricky with parties and invites, having to swap numbers with other parents, play dates with other parents and can put you in a difficult situation. At first it may seem OK but it only takes you having to speak to a parent about their child to cause some issues for your child. I'm sure there will be others who have positive success stories but personally if you did have another option it might be less stressful in the long term x