The most common and most likely answer to this crossword clue is the 5 plus 2 plus 3 plus 4 letter word SCORE AN OWN GOAL
S
C
O
R
E
A
N
O
W
N
G
O
A
L
Buddy explains!
The straight part
We know that "to shoot himself in the foot" is the straight/definition part of the clue. The straight part is often a synonym or definition, in this case to shoot himself in the foot = score an own goal.The cryptic/wordplay part
In cryptic crossword there's often an wordplay/cryptic part as well.This part involves a more complex hint, such as an anagram, homophone, hidden word, etc.
Sadly, We don't have an explanation for this specific crossword clue yet.