Like any other phobia, a fear of needles could also be won through CBT.
If blood is the concern try not to look at your tattoo during the process.
You can overcome every fear, if you want that tattoo.
Getting someone to hold your hand always helps.