There is a logical exception in the GROUP BY TIME clause of the aggregate function.

Dear InfluxDB Team, When performing an aggregate query using the `GROUP BY TIME` clause, if the `time_interval` and `offset_interval` are not equal, the query will return a large amount of data with invalid timestamps.

#### Steps to reproduce

In the latest version of InfluxDB, if we have an organization named "**organization**", we can use the Influx client to execute the following commands to create a bucket and write the specified data into that bucket.

```
influx bucket delete --name db0
influx bucket create --name db0 --org organization

influx write \
-b db0 \
-o organization \
-p ns \
't0,t0_tag0=initTag t0_f0=1 1641024000000000000'
```

Next, we use the `influx v1 shell` command to enter the Influx shell backend and execute the following query statement:

```
# query 1
SELECT COUNT(t0_f0) FROM db0.autogen.t0 WHERE time <= 1641024000000000000 GROUP BY time(8000s,8000s);

# query 2
SELECT COUNT(t0_f0) FROM db0.autogen.t0 WHERE time <= 1641024000000000000 GROUP BY time(8000s,6000s);
```

#### Expected behaviour

Query 1 returned result set: 1

Query 2 returned result set: **1**

#### Actual behaviour

Query 1 returned result set: 1

Query 2 returned result set: 1, and **a large amount of invalid data**.

#### Environment info

Influx CLI dev (git: a79a2a1b825867421d320428538f76a4c90aa34c) build_date: 2024-04-16T14:34:32Z

InfluxDB OSS v2.7.11 (git: [fbf5d4a](https://github.com/influxdata/influxdb/commit/fbf5d4ab5e65d3a3661aa52e1d05259d19a6a81b))

Linux 5.15.0-94-generic x86_64