[% USE DBI('dbi:mysql:logs','','') %] 
[% SET dbh = dbi.prepare(query) %] 
[% FOREACH user = user_list %] 
[% FOREACH item = dbh.execute(user) %] 
[% item.user %] 
[% END %]
[% END %]

##</code><code>##

$template->process(\$tt, {query => $query, user_list => [foo, bar]) or die $template->error();
[download]