ALTER TABLE `4dkankan_v4`.`t_agent_new`
    ADD COLUMN `agent_level` int NULL DEFAULT 0 COMMENT '代理等级' AFTER `status`;

UPDATE t_agent_new set `agent_level` = 1 WHERE parent_id is not null;

