"针扎似的痛" can be translated into English as "a stabbing pain" or "a sharp, piercing pain", depending on the context and the intensity you want to convey.
"A stabbing pain" implies a sudden, sharp, and often localized pain, similar to being pricked by a needle.
"A sharp, piercing pain" also conveys a similar sense of acute, intense discomfort.
Both expressions are commonly used to describe such sensations in medical or everyday contexts.