MySQL : INSERT INTO SELECT

INSERT INTO wx_announcement_push (
        title,
        content,
        STATUS,
        del_flag,
        user_login_name
        )
        SELECT
        '大家好',
        '我是曹XXX',
        0,
        '',
        su.login_name
        FROM
        sys_user su
        WHERE su.fen_xiao_Id IS NOT NULL
        AND su.fen_xiao_Id != ''