I need to count the number of unique visitors attending during any period, with a sum of each status. This query returns the error "Subquery returns more than one row." How can I work around this?

Code:
CREATE TABLE `memlog` (
	`log_id` INT(10) NOT NULL AUTO_INCREMENT,
	`m_id` INT(10) NOT NULL,
	`name` VARCHAR(60) NOT NULL DEFAULT '\'\'',
	`date` DATE NOT NULL DEFAULT '0000-00-00',
	`status` VARCHAR(10) NOT NULL DEFAULT 'Verified',
	PRIMARY KEY (`log_id`)
)
query:

Code:
SELECT  COUNT(`status`),`status` FROM memlog 
WHERE (`date` BETWEEN '2011-01-01' AND '2011-03-01')
AND (SELECT DISTINCT m_id FROM memlog)
GROUP BY `status`
Thanks,

Andy