通过用户标识mysql查询获取订单详细信息

I need to get order detail (user name, shipment method, line_items(products)) I write this query but I don't get the result.

select * from orders o
inner join user u on o.user_id=u.id
inner join shipment_method sm on o.shipment_method_id=sm.id
right join line_items l on l.order_id = o.id 
where u.id=11;

I have tried some queries but I'm stuck I don't know where.

Order Table

 id
 shipment_method_id
 user_id

line_items Table

id
order_id
product_id