Hi welcome to health care magic Here you have not mentioned your sex... According to history you might be female Your pelvic examination should be done esp. Per speculum examination to rule out candidiasis ... Nitrofurantoin good urinary antiseptic drug But if needed urine culture or if needed vaginal swab culture done to choose suitable antibiotic... Drink more water to make urine alkaline and so less soreness will be there Fruit juice taken more with less spicy food Gynecologist or physician consultation for examination...