From surenkid, 6 Months ago, written in MySQL.
Embed
  1. SELECT vv.`name` `种子姓名`,vv.mobile `种子手机`,v.`name` `顾客姓名`,v.mobile `顾客手机`
  2. FROM wfx_vip v
  3. LEFT JOIN wfx_vip vv ON SUBSTRING(SUBSTRING_INDEX(v.path,"-",2),3) = vv.id
  4. WHERE v.mobile = '13901592988'