sql - what is mysql query for below four tables -

i have 4 tables.

user:

user_id  user_name  client_id 1          abhi       1 2          ravi       2 

client:

client_id   client_name    products 1            tom          cake, patties  2            pet          cookie, cake 

products:

product_id  product_name 1            cake 2            cookie 3            patties 

report:

report_id   product_id  1              1 2              3 3              2 4              1 5              3 

if ravi login able see report below:

report_id   product_id  1               1 3               2 4               1 

i need mysql query

in "client" table instead of saving multiple values of "product" split , put "product id" rather actual product value that's why have table "product". table "client" not in first normal form. if possible, change structure of table