Hi, many thanks for the query!
Pain can be due to several causes more commonly due to stones,
infection of the urinary tract
You need to do- CBC, RFT, Urine (Culture & Sensitivity),
Random blood sugar level, USG KUB.
Start appropriate antibiotic as per report, take antispasmodics, pain killers, diuretics with your Urologist's opinion.
Drink plenty of water so that at least 2 litres of urine is voided in 24 hrs.
If diabetic, blood sugar levels must be in good control.
Wish you a good health.