Welcome to HCM,
You seem to have UTI ( Urinary Tract Infection
,so there are bacteria and pus cells in urine and you have pain during urination. You should visit a doctor/Urologist
and get your urine R&M along with Culture and sensitivity, please do not take antibiotic by yourself as some time resistant organisms are cause and really difficult to treat.
You need to drink plenty of fluids,eg craineberry juice and water and proper urinary antibiotic which may need to be modified after the report of C&S.
If pain is too much urinary antiseptic and anti spasmodic drugs may be given.
We need to know the cause of infection,some times obstruction to urine due to kidney
stone or even hygiene issue.