Select Code to Download

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

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