[PHP]ユーザテーブルの登録日ごとの件数を取得

user.php

	/**
	 * 日にち毎の会員登録ユーザ数を取得する
	 */
	public function getRegisterCountDayByDay ( $limit = 30 ) {
		$params = array(
			'fields'     => array(
				'count(1) as count',
				"DATE_FORMAT(created_at,'%Y-%m-%d') as regist_date"
			),
			'conditions' => array( 'created_at > (now() - interval ' . $limit . ' day)' ),
			'order'      => array( 'regist_date' => 'asc' ),
			'group'      => array( 'regist_date' ),
		);

		$result = $this->find( 'all', $params );
		if ( !$result ) {
			return $result[ 'User' ];
		}

		return $result;
	}