select u.username,algorithm,key,key_file from users u join authorized_keys ak on ak.uid = u.uid;