Use this phrase when a new person joins a team that you're part of: a sports team, a company that you work for, etc. You can even use this phrase jokingly in situations like when someone marries your brother or sister:

Welcome to the team, Frank.