php - Select two tables from Mysql server -

i'm trying make evaluation stars system , have 2 tables: user , evaluation. show vote every user? every answer welcome. in advance!

are looking sql query want use show evaluation rate every user? if yes, you:

select user.name username, evaluation.value evaluation_value user   inner join evaluation on user.id = evaluation.user_eval 

i think user_val in evaluation table user id. if yes can use above query. if not modify query target column save user id.