尝试此查询：

SELECT a.*, b.* FROM 
            (SELECT MAX(timestamp) as amax, id, uid FROM `test` GROUP by uid) as a,
            (SELECT MIN(timestamp) as amin, id, uid FROM `test` GROUP by uid) as b

请按表名删除测试。

分配一个街区号码是一种方法。下面的查询使用子查询中的变量来执行此操作。

select min(id) minid, max(id) maxid ,blocknumber, min(timestamp) mints, max(timestamp) maxts ,uid
from
(
select t.id,t.Timestamp,t.UID,
        if( t.uid <> @p,@bn:=@bn+1,@bn:=@bn) blocknumber,
        @p:=t.uid p
from t
cross join(select @bn:=0,@p:=0) r
order by t.id,t.uid
) a
group by uid,blocknumber
order by min(timestamp)
;
+-------+-------+-------------+---------------------+---------------------+------+
| minid | maxid | blocknumber | mints               | maxts               | uid  |
+-------+-------+-------------+---------------------+---------------------+------+
|     1 |     3 | 1           | 2018-01-01 00:00:00 | 2018-01-01 00:00:01 |    1 |
|     4 |     6 | 2           | 2018-01-01 00:00:01 | 2018-01-01 00:01:00 |    2 |
|     7 |     8 | 3           | 2018-01-01 00:01:02 | 2018-01-01 00:02:00 |    3 |
|     9 |    11 | 4           | 2018-01-01 00:05:00 | 2018-01-01 00:05:02 |    1 |
+-------+-------+-------------+---------------------+---------------------+------+
4 rows in set (0.08 sec)