SELECT a.id, a.user_name, a.user_type, a.parent_uid, b.limit_num, b.uid FROM pms_users a LEFT JOIN pms_recommend_limit b ON a.id = b.uid WHERE a.user_type = '89' AND a.parent_uid = '0'