So there are basically two ways to achieve that.
First one - Linking Accounts
The user can signup with email/password and then link the social and the db users
Second one - export-import
You can export the users from the social connection and then import in a regular database. Then, the users will need to reset their passwords.