sql处理逻辑请教

qiu_hong_yun

with t as
(select 1 as id,122 column1, 'a_123' as column2
union all
select 2 as id,123 column1, 'a_123' as column2
union all
select 3 as id,123 column1, 'a_124' as column2
union all
select 4 as id,124 column1, 'a_124' as column2
union all
select 5 as id,125 column1, 'a_125' as column2
)

通过column1 分组。id为2和3的是一组，
通过column2 分组。id为1和2是一组，3和4是一组

通过上面两个关系。id为1、2、3、4是同一组
请问 sql 怎么实现

预期结果为

id column1   column2  new_id
1   122   a_123   1
2   123   a_123   1
3   123   a_124   1
4   124   a_124   1
5   125   a_125   5