With respect to the claim that urotherapy can cure cancer, the American Cancer Society has this to say:
No well-controlled studies published in available scientific literature support the claims that urotherapy can control or reverse the spread of cancer.
It goes on:
What is the evidence?
There are some individual reports of urotherapy's ability to stop cancer growth. However, available scientific evidence does not support claims that urine or urea given in any form is helpful for cancer patients. Two small studies done during the 1980s found urea did not cause tumors to shrink in patients with cancer in the liver.
Are there any possible problems or complications?
Individuals have reported that drinking or injecting urine or applying it directly to the skin is safe and not linked to any harmful side effects, but the safety of these practices has not been established by scientific studies. There have been reports of nausea, vomiting, upset stomach, and diarrhea after drinking one's own urine, especially during the first few days. Some medications are excreted into the urine, and by drinking their own urine, patients can accumulate toxic levels of these drugs.
Relying on this type of treatment alone, and avoiding or delaying conventional medical care for cancer, may have serious health consequences.
So, no. There is no evidence that drinking your own urine will cure cancer. It can potentially cause more harm than good.