CREATE TABLE IF NOT EXISTS `yf_user_sub_user` ( `sub_user_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '子账号用户id', `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属主账号id', `sub_user_active` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否激活', PRIMARY KEY (`sub_user_id`), KEY `user_main_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='买家子账号表' AUTO_INCREMENT=1 ; 判断当前帐号是不是有主帐号 sub_user_id=*发前登录用户ID*&sub_user_active=1&user_id>0