SELECT book_class, COUNT(*) AS total
FROM `bk_trx` LEFT JOIN books ON bk_trx.`book_no_perolehan` = books.`book_no_perolehan`
WHERE bk_trx.`dateout` LIKE '%2019%'
AND `dateout` LIKE '01/%'
AND bk_trx.`std_class` = '5'
GROUP BY books.`book_class` , bk_trx.`std_class`

SELECT `trx_id`, `std_class`, `std_class_name`, `book_no_perolehan`, `dateout`
FROM `bk_trx`

trx_id,    std_class,  std_class_name,  book_no_perolehan,     dateout

1     ,    5        ,  H             ,  33481            ,     01/12/2019

2     ,    5        ,  B             ,  33491            ,     01/13/2019

SELECT `book_id`, `book_no_perolehan`, `book_class`
FROM `books`

book_id , book_no_perolehan , book_class

1       , 33481             , F

2       , 33491             , 800

3       , 33450             , FCL

book class  , Total

800         , 1

50C         , 1

book class , Total
800        ,  1
FCL        ,  0
50C        ,  1