You should drink water a lot.
Have a urine sample again for routine examination and for culture sensitivity to have some pus cells and blood
Do an ultrasonography
for kidneys ureter
and bladder to rule out any obstruction.
For acute relief of pain have a pain killer injection for that that can relief acute attack of pain
If u have any pus cells in urine and show specifity to antibiotic for that to relief of your pain.
I hope I am succesful in solving in your query if you have more you can ask me
Dr. Azhar Sattar