I'm a beginner in MySQL, so I need help. 
I want to get values of `name` column from table `role` to show it together with information from `users` instead `id_role`.
How can I realize it? What should the query I write? 
Can you attach the link with solve?

The picture for explanation.
![click to see](https://i.stack.imgur.com/MT2Ii.jpg)