Shoot Yourself in the Foot:

If you shoot yourself in the foot, you do something to yourself that will hurt you and will have a negative influence on you and your life.

I shot myself in the foot by showing up late for the interview.

Persian: خود را به درد سر انداختن