select a.OrderId,a.id,a.paymode_id,a.createtime,b.consignee_name,b.consignee_mobile,b.consignee_province,b.consignee_address,c.user_name from lk_order as a left join lk_users as c on a.userId=c.id ,lk_order_consignee as b where a.id=b.order_id

$sql="select a.OrderId,a.id,a.paymode_id,a.createtime,a.order_price,b.consignee_name,b.consignee_mobile,b.consignee_province,b.consignee_address,c.user_name from lk_order as a left join lk_users as c on a.userId=c.id ,lk_order_consignee as b where a.id=b.order_id";