try:SELECT a.* ,b.id as user_productid ,b.auditing ,f.unitname ,e.typename ,g.typenum ,c.product_num ,c.zbxh ,c.product_money ,h.* FROM product_basic a left join bid_product c on c.product_basicid=a.id left join user_product b on c.bidid=b.bidid and b.bid_productid=c.id left join product_type e on a.typeid=e.id left join unit f on a.unitid=f.id left join bid_type g on g.typeid=e.id left join product_qt h on h.user_productid=b.id where b.id=29
,b.id as user_productid
,b.auditing
,f.unitname
,e.typename
,g.typenum
,c.product_num
,c.zbxh
,c.product_money
,h.*
FROM product_basic a
left join bid_product c on c.product_basicid=a.id
left join user_product b on c.bidid=b.bidid and b.bid_productid=c.id
left join product_type e on a.typeid=e.id
left join unit f on a.unitid=f.id
left join bid_type g on g.typeid=e.id
left join product_qt h on h.user_productid=b.id
where b.id=29