Shoot oneself in the foot

Meaning: To do something that harms one’s own interests.

Example: By insulting his biggest customer, he shot himself in the foot.