SELECT user.username, branch.name
FROM user
INNER JOIN branch ON user.branch_id = branch.id