I shot myself in the foot with a .22 caliber pistol
What caused you to do something like this?
I thought I could handle the pain but it was too much.
I can imagine that it was very painful. Shooting yourself in the foot, or anywhere else, is extremely dangerous. I don't think you should do that anymore.
I just wanted to have some fun, it only minor wound.
It's good that the wound was only minor, but that might not always be the case. You could easily cause major damage, or even death. I think you should stop playing with guns like that altogether.