$query = $db->execute("
    SELECT
        (SELECT COUNT(mm.toID) FROM userMessages_map as mm WHERE mm.msgID = m.id) as userCount,
        m.id,
        u.displayName,
        u.avatar,
        m.subject,
        m.time
    FROM
        " . TBL_USERS . " as u
        JOIN " . TBL_USERMESSAGES . " as m
        JOIN userMessages_map as mm
    WHERE
        m.fromID = " . $user->id . "
        AND mm.msgID = m.id
        AND u.id = mm.toID
        AND m.fromDeleted = 0
    GROUP BY m.id
    ORDER BY m.time DESC
");