How many cameras can be connected to a lamp socket?

Only 1 (one) Wyze Cam v3 per lamp socket.

There is no way to connect multiple Wyze Cams to a single lamp socket for power, or vice versa.