PHP Code:
$pw=$DB_site->query("SELECT password FROM forum WHERE forumid=YY");
$users=$DB_site->query("SELECT userid FROM user WHERE usergroupid=XXX");
while($user=$DB_site->fetch_array($users)) {
$DB_site->query("INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,folderid,title,message,dateline) VALUES (NULL,$user[userid],$user[userid],1,0,'New password','".addslashes($pw[password])."',".time().")");
}