Thinkphp framework generates the SQL statements,

SELECT count (*) as tpcount FROM s_member Member LEFT JOIN s_usergroup Usergroup ON Member. The groupid=Usergroup. Id

Is no problem in the original environment, upgrade the running environment MYSQL8 after the complains, the SQL statement to execute in PHPMyAdmin warm-ups and found to be the table alias problem;

Table alias is an error,

SELECT count (*) as tpcount FROM s_member LEFT JOIN s_usergroup ON s_member. Groupid=s_usergroup. Id

Such a problem, this is how to return a responsibility? MYSQL8 does not support the table alias?