He was pierced

Psalm 22:12-18 - Many bulls surround me;
strong bulls of Bashan encircle me.

Roaring lions tearing their prey
open their mouths wide against me.

I am poured out like water,
and all my bones are out of joint.
My heart has turned to wax;
it has melted away within me.

My strength is dried up like a potsherd,
and my tongue sticks to the roof of my mouth;
you lay me in the dust of death.

Dogs have surrounded me;
a band of evil men has encircled me,
they have pierced my hands and my feet.

I can count all my bones;
people stare and gloat over me.

They divide my garments among them
and cast lots for my clothing.

The first part of this psalm is obviously quoted and fulfilled by Jesus many years later at the time of his crucifixion. I can't think of a time when this literally happened to David though, so I wonder if he is speaking metaphorically about himself or if this really did happen and it just isn't recorded elsewhere for us.