Can you get a Pilot's license in CA with a DUI?

Pilot licenses are issued by the Federal Government, not individual states. The issue would be chemical dependency, and that determination has to be made by the Aviation Medical Examiner (AME) when you take your physical. You can call any AME and discuss it with them.