Have you tried thus?

Pyridium (phenazopyridine) is specifically used to relieve the burning, pain, urgency, and discomfort associated with urinary tract irritation, which often includes the burning sensation while peeing.
It is available over the counter