OpenAI CEO Sam Altman has joined a growing list of former tech leaders taking roles in San Francisco's government following this month's election.