I am using an old version of PHP symfony MVC framework. In the controller I have written two different query
$query1 = FrontGateModelsEvents::query();
$query2 = SELECT Events.ID, count(EventTicket.ID) as NumOfTickets from EventTicket INNER JOIN Event On Event.ID = EventTicket.EventId where ..
The first query is a database model query. The result of first query is like following.
Array (
[0] => Array
(
[name] => ID
[table] => Events
)
[1] => Array
(
[name] => Name
[table] => Events
)
)
In the twig template I have displayed the result of first query like following.
{% for event in Events %}
<tr>
<td>
<label class="stack-label">Name</label>
{{ event.ID }}
</td>
<td>
<label class="stack-label">Name</label>
{{ event.Name }}
</td>
</tr>
{% endfor %}
Now I want to put the data of second query in a third column of the above table . That column will be number of tickets. The second query is a simple select query. Result of 2nd Query is
Array
(
[0] => Array
(
[ID] => 1
[NumberOfTickets] => 21
)
[1] => Array
(
[ID] => 2
[NumberOfTickets] => 12
)
What Shall I do or how can i bring the value of Number of tickets (from the second query result ) in the relevant row.