SELECT k.id,
k.agreement_no,
k.org_first_id,
b.group_id,
c.org_id,
c.state FROM
treaty.consignment k
LEFT JOIN customer.share_customer b ON k.org_first_id =b.group_id
LEFT JOIN customer.sale_customer c ON c.org_id = b.id
SELECT k.id,
k.agreement_no,
k.org_first_id,
b.group_id,
c.org_id,
c.state FROM
treaty.consignment k
LEFT JOIN customer.share_customer b ON k.org_first_id =b.group_id
LEFT JOIN customer.sale_customer c ON c.org_id = b.id