yDztCA0u

1SELECT u.*, s.statusdesc AS ststatus, p.plandesc, p.planval,
2                (SELECT COUNT(*) FROM usuarios WHERE uscpfindicador = u.uscpf) AS indicados
3            FROM usuarios u, planos p, usstatus s
4            LEFT JOIN usuarios AS child
5                ON child.usid = usid
6            WHERE u.usstatus = s.statusid
7                AND u.usplano = p.planid
8                AND u.uscpfindicador = 0123456
9            GROUP BY u.usid;
10	
11CREATE TABLE IF NOT EXISTS `usuarios` (
12  `usid` int(11) NOT NULL AUTO_INCREMENT,
13  `usnome` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
14  `usnascimento` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
15  `uscpf` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
16  `ustelefone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
17  `uscelular` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
18  `uscpfindicador` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
19  `usvencimento` int(11) NOT NULL,
20  `usendereco` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
21  `usbanco` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
22  `usagencia` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
23  `usconta` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
24  `usoperacao` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
25  `usfavorecido` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
26  `usemail` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
27  `ussenha` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
28  `usvendedor` int(11) NOT NULL DEFAULT '1' COMMENT 'boolean',
29  `usstatus` int(11) NOT NULL DEFAULT '1',
30  `usplano` int(11) NOT NULL DEFAULT '1',
31  `usdepende` int(11) DEFAULT NULL COMMENT 'se o usuário for dependente de alguém, o id do usuário do qual ele depende',
32  `ustipocad` int(11) DEFAULT NULL,
33  `usparentesco` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
34  `usadmin` int(11) DEFAULT '0',
35  `recover` int(11) DEFAULT '0',
36  PRIMARY KEY (`usid`),
37  UNIQUE KEY `uscpf` (`uscpf`),
38  KEY `usplano` (`usplano`),
39  KEY `usstatus` (`usstatus`),
40  KEY `FkTipoCad` (`ustipocad`)
41) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
42	
43INSERT INTO `usuarios` (`usid`, `usnome`, `usnascimento`, `uscpf`, `ustelefone`, `uscelular`, `uscpfindicador`, `usvencimento`, `usendereco`, `usbanco`, `usagencia`, `usconta`, `usoperacao`, `usfavorecido`, `usemail`, `ussenha`, `usvendedor`, `usstatus`, `usplano`, `usdepende`, `ustipocad`, `usparentesco`, `usadmin`, `recover`) VALUES
44(1, 'EMPRESA', '1988-05-29', '0123456', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'email@email.com', '7bca1fa5a8bcc4df3933e77c644b8cd1', 1, 1, 1, NULL, 3, NULL, 1, 0),
45(2, 'Indicado pela empresa', '1992-03-22', '12345678910', '210000000', '21900000000', '0123456', 10, NULL, NULL, NULL, NULL, NULL, 'Jhonatan Pereira', 'jhonatan_pereira@msn.com', '709aae0fea527912f8a02cf1d7c20819', 1, 1, 1, NULL, 3, NULL, 0, 0),
46(6, 'Indicado pelo indicado', '1992-03-22', '12312312311', '210000000', '21900000000', '12345678910', 10, 'Av Teste', '', '', '', '', '', 'email@email.com', '709aae0fea527912f8a02cf1d7c20819', 1, 1, 1, NULL, 3, NULL, 0, 0);