How to safely convert 120VAC from a lamp bulb socket to 12VDC
I'm not sure if they make AC adapters that screw into light sockets.  I would suggest finding a small wall wart that will provide the necessary voltage and current and a separate light bulb socket adapter that you can plug it in to.