From surenkid, 5 Months ago, written in MySQL.
Embed
  1. SELECT pid 上级ID,plv 层级,mobile 手机,`name` 姓名,nickname 昵称
  2. FROM wfx_vip
  3. WHERE mobile = (
  4.   SELECT DISTINCT mobile
  5.   FROM wfx_agent
  6.   WHERE mobile = '18230662923'
  7.   LIMIT 1
  8. )