array with struct in coldfusion

array with struct - Create Json using array with struct in coldfusion 

<cfquery name="GetUsers" datasource="TestDB"> 
    SELECT UserID, UserName,Active,
    CASE Active
        WHEN 1 THEN 'Active'
        WHEN 0 THEN 'InActive'
        END AS Status
    FROM shema_users        
</cfquery>

<cfset resultStruct = Structnew() />
    <cfset JsonArray = ArrayNew(1) />
    <cfset Counter=1>
    <cfloop query="GetUsers">  
     
       <CFSET color = FormatBaseN(RandRange(0,255), 16) 

                      & FormatBaseN(RandRange(0,255), 16) 

                      & FormatBaseN(RandRange(0,255), 16)>    
        <cfset JsonArray[Counter] =  Structnew() />
        <cfset JsonArray[Counter]["UserID"] = "#UserID#" />
        <cfset JsonArray[Counter]["UserName"] = "#UserName#" />
        <cfset JsonArray[Counter]["Active"] = "#Active#" />
        <cfset JsonArray[Counter]["color"] = "###color#" />
        <cfset Counter=Counter+1>
    </cfloop>
    <cfdump var="#SerializeJSON(JsonArray)#">