How to create user for another database using current database in SQL?

We can use the T-SQL’s to create user command for SQL server and add user to database. It has the following syntax:

create user <user-name> for login <login-name>