average rating calculation mysql php -

i want calculate average rating of every user.

i have 3 table.

table rating

id |order_id |rate ------------------ 1  | 52      |8 2  | 51      |4 3  | 52      |2 4  | 51      |7 

table order

here did driver table id

id |did ------------------ 52  | 5  51  | 7  35  | 6  44  | 8  

table driver

id |name  ------------------ 5  | test1  7  | test2  8  | test3  6  | test4  

my sql query is

select dr.name,avg(drate.rate) `rating` drate,`order` ord,`driver` dr ord.did=dr.id , drate.order_id=ord.id  

my query give result 1 .

here want select average rate rating table relation rating table order_id= order table id , order table did =driver table id

that means

order_id(rating table) |id(order table) |id(driver table) |rate ------------------------------------------------------------------- 52                     | 52             |5                |avg(8,2) 51                     | 51             |7                |avg(4,7) 

if order.did user id, then

select order.did, avg(rate) rating join order on order.id = drate.id group order.did