

SELECT 
  vc.customerSid 客户sid,
  lc.wxMpOpenid OpenID,
  lc.nick 客户昵称, 
  lc.mobile 客户电话,
  pb.name 菜窖类型,
  lg.name 商品名称,
  vc.goodsNumber 商品数量
FROM vegetable_cellar vc 
LEFT JOIN lpk_customer lc ON lc.sid=vc.customerSid 
LEFT JOIN lpk_goods lg ON lg.sid=vc.goodsSid
LEFT JOIN pms_brand pb ON pb.id = vc.affiliation
WHERE lc.mobile='18632141515'



SELECT 
  lc.nick 客户昵称, 
  lc.mobile 客户电话,
  tcg.bindDate 记录时间,
  tcg.serialNumber 卡序列号,
  tcg.goodsName 商品名,
  tcg.goodsNumber 商品数量,
  tcg.cardtype 卡类型
from tmp_cust_goods tcg
LEFT JOIN lpk_customer lc ON lc.sid=tcg.customerSid 
WHERE lc.mobile='18632141515'