A php web little code

[Faraonekkk]

I need a line that will search from sql group_id = 7

$main_content .= '<center><h2>Support in game</h2></center>';
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%>
<tr bgcolor=\"".$config['site']['vdarkborder']."\">
<td width=\"20%\"><font class=white><b>Group</b></font></td>
<td width=\"45%\"><font class=white><b>Name</b></font></td>
<td width=\"15%\"><font class=white><b>Status</b></font></td>
<td width=\"20%\"><font class=white><b>World</b></font></td>";
foreach($list as $gm) {
if($gm['online'] == 0)
$player_list_status = '<font color="red">Offline</font>';
else
$player_list_status = '<font color="green">Online</font>';

this line

foreach($list as $gm) {

need to change to search group id 7

Help please

for a help in bans i have that line

$SQL->myQuery('SELECT players.name, bans.expires, bans.active FROM bans, players WHERE bans.type = 2 AND players.id = bans.value OR bans.type = 3 AND players.account_id = bans.value ORDER BY expires ASC');