This infographic basically explains it:

https://www.ppic.org/publication/water-use-in-california/

tl;dr: Urban water use is tiny. In NorCal, the vast majority of the water flows unimpeded to the sea. In the Central Valley, most water is used for agriculture. Agricultural water use in any one of the 3 major basins in the Central Valley is more than all urban areas in California combined. Unsurprisingly, urban use is the primary one in the SF and LA areas, but the absolute totals are very small compared to total CA water supplies.