Hello, and thanks for your medical question on ehealth forum.
Based on the history, it seems that you may be having either a renal cyst or a renal stone, which may have been described as a hole in the kidney. Presence of an actual hole in the kidney would lead to serious issues including urine drainage within the pelvic cavity and severe renal infections.
Presence of severe pains and need for pain killers indicate that the problem here may be a renal stone. Presence of smaller stones can be treated conservatively. But larger stones causing severe pain and other symptoms may need some therapeutic interventions.
Also the history of recurrent UTI's indicate that you may be having Struvite stones. Specifically, infections with urease-producing bacteria (Ureaplasma urealyticum and Proteus species (most common), Staphylococcus species, Klebsiella species, Providencia species, and Pseudomonas species) are associated with struvite stone formation. Struvite calculi account for up to 30% of urinary tract stones and are more frequent in women.
You might consider consulting a physician or a urologist for a physical examination and a few diagnostic tests including a urinalysis, urine culture sensitivity which can help know the cause of recurrent UTIs and this will help to initiate necessary treatment.
Dietary modifications can be initiated once the type of stone is diagnosed to prevent recurrances, once the the problem is adequately treated.
I hope you find this information useful.