grocery CRUD SQL issues in MYSQL 8.0.31

[jianhui99]

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM admin_users LEFT JOIN admin_departments as jbf691be4 ON `jbf69' at line 1

SELECT admin_users.*, jbf691be4.outlet AS sbf691be4, (SELECT GROUP_CONCAT(DISTINCT admin_groups.name) FROM admin_groups LEFT JOIN admin_users_groups ON admin_users_groups.group_id = admin_groups.id WHERE admin_users_groups.user_id = admin_users.id GROUP BY admin_users_groups.user_id) AS groups FROM admin_users LEFT JOIN admin_departments as jbf691be4 ON jbf691be4.id = admin_users.department_id

Filename: third_party/grocery_crud/models/Grocery_crud_model.php

Line Number: 87