CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `root`@`localhost` 
    SQL SECURITY DEFINER
VIEW `dbrecoleccion`.`usuario_cobros` AS
    SELECT 
        `a`.`idusuario` AS `idusuario`,
        `a`.`idservicios` AS `idservicios`,
        `a`.`codigo` AS `codigo`,
        `a`.`total` AS `total`,
        `a`.`fecha_cobro` AS `fecha_cobro`,
        `b`.`nombre` AS `nombre`,
        `b`.`perfil` AS `perfil`,
        `b`.`usuario` AS `usuario`
    FROM
        (`dbrecoleccion`.`cobros` `a`
        JOIN `dbrecoleccion`.`usuarios` `b` ON ((`a`.`idusuario` = `b`.`id`)))