Select Query to create a new field and fill in

My query

Create table quad2017_1
select different
`a“event_id` AS` event_id`,
`a“user_ID` AS` user_ID`,
`a“date` AS` date`,` a` `Time` AS` Time`,
`a“Noise` AS`Noise`,` a` `Signal` AS` Signal`
of (`quadrantids2017“ a` join` quadrantids2017“ b`)
where ((`a“date` =` b“date`)
and (`a“user_ID` <>` b“user_ID`)
and ((time_to_sec (`a“ Time`) – time_to_sec (`b“Time`)) between – (1) and 1))
order by `a“date`,` a` `Time`,` a“user_ID`

produces an output like this (event_id, user_id, date, time)

37776 2 2017-01-01 01:08:45
47827 3 2017-01-01 01:09:07

33501 1 2017-01-01 01:14:59
47828 3 2017-01-01 01:15:00

33503 1 2017-01-01 01:24:48
47829 3 2017-01-01 01:24:49
37781 2 2017-01-01 01:24:53

Is there any way I can get to produce this?
(event_id, user_id, date, time) and fill in a new field called group

37776 2 2017-01-01 01:08:45 1
47827 3 2017-01-01 01:09:07 1

33501 1 2017-01-01 01:14:59 2
47828 3 2017-01-01 01:15:00 2

33503 1 2017-01-01 01:24:48 3
47829 3 2017-01-01 01:24:49 3
37781 2 2017-01-01 01:24:53 3

that way when I show online I can show in groups
SEMrush

regards
John b