Without COLLATE: <pre class='xdebug-var-dump' dir='ltr'>
<small>/Users/rvanvuren/Projects/buyerkiosk-web/userfrosting/scripts/test-group-query.php:10:</small>
<b>array</b> <i>(size=2)</i>
  'id' <font color='#888a85'>=&gt;</font> <small>int</small> <font color='#4e9a06'>222</font>
  'name' <font color='#888a85'>=&gt;</font> <small>string</small> <font color='#cc0000'>'ou21000'</font> <i>(length=7)</i>
</pre>COLLATE error: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb3_general_ci' is not valid for CHARACTER SET 'utf8mb4'
Done.