Columnas con Prefix

[Libras]

Código MySQL:

SELECT u.id as user_id, ab.id as ab_id........ FROM user AS U
    INNER JOIN assignedbranch AS AB
    ON U.Id = AB.UserId
    INNER JOIN userpermission AS UP
    ON Up.AssignedBranchId = AB.Id
    INNER JOIN Branch AS B
    ON B.Id = AB.BranchId
    WHERE U.Username = paramUsername;
 

Algo asi