SELECT
table_authentication.table_authenticationid,
table_authentication.tableval,
users.username as 'users.username',
user_groups.description as 'user_groups.description',
table_authentication.read_rights as 'table_authentication.read_rights',
table_authentication.add_rights as 'table_authentication.add_rights',
table_authentication.edit_rights as 'table_authentication.edit_rights',
table_authentication.delete_rights as 'table_authentication.delete_rights'
FROM
table_authentication
Left Join users ON users.usersid = table_authentication.usersid
Left Join user_groups ON user_groups.user_groupsid = table_authentication.user_groupsid