There is a double position after JOIN!

SELECT * FROM user_order as c
        LEFT JOIN product_order AS b ON c.order_id = b.order_id
        LEFT JOIN product AS a ON a.prod_id = b.prod_id
        WHERE c.id = "16"

too expensive
my user_order list has name, id
my product_order also has id
my product also has name
I all have prod_id bits

is there no way for me to show some data now?
for example, I just want to show the name, of product, not the name. of user_order
. How did this happen? How can it be improved?
update

id = user_id
my user_order has order_id, id, name.
my product_order has order_id, prod_id, id
my product has prod_id, name, icon

what I mainly want to show is user_order, but show the trade name of product
I will send the goods to product_order with purchased goods
, that is, it will be like this

product_order:

so I know which prod_id (merchandise)
list 9 has prod_id
but I want to show his merchandise in user_order
that is, order_id 8 merchandise has 1pime3 prod_id 4
I want to show name, icon

Php mysql mysqli php7

Mar.22,2021

SELECT a.name FROM user_order as c
        LEFT JOIN product_order AS b ON c.order_id = b.order_id
        LEFT JOIN product AS a ON a.prod_id = b.prod_id
        WHERE c.id = '16'
    select

first sort out the relationship between tables and the meaning of each field, and then operate
it is suggested that the table structure and the meaning of each field should be pasted, and the target result should be pasted

Previous: SQL look up data

Next: Element form calculation synthesis, how to invoke the results in other locations.