The inventive member of the Los Angeles-based studio musicians performed on hits by the Beach Boys, Mamas and Papas, Sonny & Cher, and many more