"Print" specific columns through foreign keys
Table Users has the id column, that column is related on
  Users_request.id finally Users_request.id is related with
  Users_applications.id


So Users.id = Users_request.id and Users_request.id = Users_applications.id which means that Users.id = Users_applications.id

Then you can do:

SELECT Users.id, Users_applications.name 
FROM Users INNER JOIN Users_applications  ON Users.id = Users_applications.id
WHERE Users.id = 'User1';